Measures as rows in pivot table

[mfarsln]

Hello,

I need to use my measures as pivot table rows. Is it doable with standard pivot table object?

An example of desired result is like below;

	Company-1	Company-2	Company-3
Avg. Rent	100	150	200
Avg. M2	10	20	50
Avg. Rent/m2	10	7,5	4

[Anil_Babu_Samineni · Accepted solution]

You can create static dimension for that with measures like

Dimensions

Valuelist('Avg. Rent', 'Avg. M2', 'Avg. Rent/m2')

Company // Drag this to row

Measure

If(Valuelist('Avg. Rent', 'Avg. M2', 'Avg. Rent/m2')='Avg. Rent', Expression for Avg. Rent,

If(Valuelist('Avg. Rent', 'Avg. M2', 'Avg. Rent/m2')='Avg. M2', Expression for Avg. M2,

If(Valuelist('Avg. Rent', 'Avg. M2', 'Avg. Rent/m2')='Avg. Rent/m2', Expression for Avg. Rent/m2)))

[mfarsln]

Thank you so much!

[Patrik_Lundblad]

You can also just move the measure values to row and the dimension to column. 

[mfarsln]

Thanks for your reply but i couldn't find the way to do this. Can you provide me a sample qvf?

[mfarsln]

One last question.

I am using 2 dimensions in my pivot table. First one is month and second one is valuelist dimension. What if i want to get totals for each valuelist dims? Adding sums of those dims to valuelist function doesn't work since there is an another dimension exists.

I'm trying to achieve something like this;

[Patrik_Lundblad · Accepted solution]

Hi,

Here is what it looks like using your data.

Also attached the qvf. 

Regards,

Patrik.

[Patrik_Lundblad]

And here is a video of what I did. 

Regards,

Patrik.

[mfarsln]

Thank you so much!

[Sa_Rah]

Thank you very much for this! It's exactly what I needed.