4 Replies Latest reply: Feb 11, 2016 4:48 PM by Josephinet Tedesco RSS

    Total of a column/rows on a pivot table

    Josephinet Tedesco

          Hi All

      the pivot table when using Set Analysis is working well - but I want to add a TOTAL to both the Column on the right and to the bottom line.


      I have included both the spreadsheet and the qlik file.  Is there some other way of doing this?  I experimented with the Calculate Dimension - I have never used one before but I am not sure how this is use.  The calculation I used did not work on the pivot table ...


      Feb 2016NewCase3424
      Feb 2016Finish0110


      Thank you