Hi, Can someone help how to show multiple measures as separate columns instead of Data fields - ROWS when report output is EXL2K PIVOT. I need this to do offline drill down on counts plus other columns displayed default and giving users extra columns as optional CACHEFIELDS.
I see this belpw option but If I have multiple detail level columns in the same hold file I will be doing PRINT 1 field BY 20 fields. And I won't have drillable option on the other columns(BY fields) I need in PIVOT.
This won't work - From another post to show DEALER_COST, RETAIL_COST, SALES as multiple columns instead of rows(no drill option)
Print SEATS so COSTs and SALES become columns: TABLE FILE CAR SUM DEALER_COST RETAIL_COST SALES/D8 SEATS BY COUNTRY BY CAR BY MODEL ON TABLE HOLD AS HOLD1 END -* TABLE FILE HOLD1 PRINT SEATS BY COUNTRY BY CAR BY MODEL BY DEALER_COST BY RETAIL_COST BY SALES ON TABLE SET BYDISPLAY ON ON TABLE PCHOLD FORMAT EXL2K PIVOT END
*************LOOKING FOR SOMETHING LIKE THIS************* TABLE FILE CAR PRINT DEALER_COST RETAIL_COST SALES/D8 SEATS BY COUNTRY BY CAR BY MODEL ON TABLE PCHOLD FORMAT EXL2K PIVOT END
But the PIVOT output displays them as ROWS and not separate columns with drill option.
PLEASE help!!
Thank you, RKThis message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8.1.05 Excel, PDF, Pivot, HTML Windows
April 09, 2018, 01:44 PM
FP Mod Chuck
Riya
Since no one has been able to provide any guidance I suggest you open a case with techsupport.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats