9 Replies Latest reply: Aug 22, 2017 2:56 PM by Robin Cushman 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