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

    Total of a column/rows on a pivot table

    Jo 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 ...

       

      =monthname(Date)LocationEastNorthSouthWest 
      Feb 2016NewCase3424
      Feb 2016Finish0110

       

      Thank you

      Jo