Have Measurement Data Values Become Columns For Pivot Tables.

Question

We have had multiple reports that have values as column headers for some of our reports and this allows our Fiscal periods to be right next to each other so they are easier to compare. Unfortunately, FAW does not allow this capability of putting a measure into the column values for a pivot table.  For example, for period actuals in the picture below if I wanted to compare multiple fiscal periods they will be separated by the other 3 values that are in the visual. Is there a method to get around this problem?

Cade Johnston · Answer

Thank you @Madasamy -Oracle! I will look a little more into this problem!

Madasamy -Oracle · Answer

With multiple measures, this may not be an option as the Fiscal year and Period will be sorted on the columns side first and then the list of measures will be listed per the order of selection in DV workbook

I could see the same behavior on sampleapp based DV Workbook.

Maybe you can create an idea through the Enhancement if you'd like sorting based on the measures as well.