2 Replies Latest reply: Dec 29, 2015 5:38 AM by Mohammed Sleem RSS

    show the subtraction column in pivot table



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

      Sun table.png


      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:


      Sun table - should be.png


      any idea how I can do that.