8 Replies Latest reply: Oct 14, 2015 8:36 AM by Joanna Seldon RSS

    Grand Total Pivot table

    Joanna Seldon

      Hiya

       

      I have lots of customers (Customer ID) that have orders under a department e.g  catering, finally  and sub specialties (plates)

       

      I have a pivot table showing number of sales per month for year (2014) for each department, which you can expand to show the  sub specialties, number of sales

       

      I would like to add a grand total column along the bottom for each month for each specialty

       

      is this possible in qlik sense?

       

      please help