As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
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.
Thank you, RKThis message has been edited. Last edited by: FP Mod Chuck,