Is it possible to use a measure as dimension in Pivot Table.
I want to show 'price' (a fact table) as a row.
Is it possible?
Hi, Marat. Try to add a calculated dimension with yor measure
Drag Measure in Row & Dimension in Column in the Pivot Table
Thanks, but when I add a measure as dimension, then it creates extra row for each item.
I get one row where I have proper measure (sales) and another row where I have sales price which is what I need - but on another row :-(
Please send the image of desired output
Retrieving data ...