Measure as dimension in Pivot Table

[Anonymous]

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?

Thanks

[andrey_krylov]

Hi, Marat. Try to add a calculated dimension with yor measure

[priyalvp24]

Hi,

Drag Measure in Row & Dimension in Column in the Pivot Table

Thanks,

Priyal

[Anonymous]

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 😞

[Anonymous]

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 😞

[Anonymous]

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 😞

[priyalvp24]

Please send the image of desired output

[Anonymous]