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

    show the subtraction column in pivot table

    Mohammed Sleem

      Hi,

       

      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.