When creating a PIVOT table, WF automatically presents the verb object as Row Labels. Is there a way to have them displayed automatically as Column Labels?
DEFINE FILE CAR 2_WE/D7=WEIGHT*2; END TABLE FILE CAR PRINT WEIGHT 2_WE BY CAR ON TABLE PCHOLD FORMAT EXL2K PIVOT ENDThis message has been edited. Last edited by: Danny-SRL,
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
Unless you deliver the basic data and then use a macro to generate the pivot; I do not think so.
Are you expecting the below ouput?
DEFINE FILE CAR 2_WE/D7=WEIGHT*2; END TABLE FILE CAR PRINT WEIGHT 2_WE ACROSS CAR ON TABLE PCHOLD FORMAT EXL2K PIVOT END
OS: Windows XP
What I've learned recently is that its not WF that presents the verb object as Row Labels (my opinion at least), but the way a pivot table behaves in general. If you were to create a pivot table manually you would see the same thing happening in Excel. What I learned is that Excel only puts the verbs across the top when you drag the data tab into the across sort area of the Pivot Table.
Recently we've had more users asking for this sort of thing by us, where as I haven't been able to actually put a proof of concept together, but I think the solution would be to create a by field to that as just a count of your verbs and put your file into a sort of up and down setup, then take that sort field and make it an across. The only problem is that you can't make that across field a noprint so you might want to style it as white text to hide it.
ie. IF SORT EQ 1 THEN RETAIL_COST ELSE IF SORT EQ 2 THEN DEALER_COST
Something like that while using a MacGyver type of technique to create your sort column.
WF 7.6.7 Reportting Server
Dev Studio 7.6.7
How would you like to be able to control the Excel pivot table AND get it to create a pivot chart as well?
I have an Excel template that allows you to do just that and the fex to populate would look like this -
|Powered by Social Strata|