Difference Measure in a Pivot Table

[harsh44_bhatia]

Hello All,

I have a case with Pivot table where i need the difference between the Current Year and Prior Year values.

In my data model i have normalized the data set by Current year and Prior Year. So that i can use this flag to pivot in pivot table by writing just one expression. But along with this i also need difference between the prior and current year value.

i have attached a qvw file with pivot table and a straight table. i need something like the straight table but on a pivot table.

[Anonymous]

What is the issue?

Change same Straight Table into Pivot Table??

[tamilarasu · Accepted solution]

Hi,

Check the attachment.

[harsh44_bhatia]

Thanks Tamil.