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.