show the subtraction column in pivot table

[mohammedsleem]

Hi,

in the attached QVW sample, I have a table which looks as shown in the below image.

I want to show a pivot table in my dashboard that shows the count of records per each type and year (the current year and the previous year only) then show a column display the subtraction between the two years summing results for each type. The pivot table should looks like that:

any idea how I can do that.

[Kushal_Chawda · Accepted solution]

if its is always current Vs Prev then you can do something like this

see the attached

[mohammedsleem]

Thanks a lot. This is working fine.