1 Reply Latest reply: Jun 25, 2012 9:41 AM by Gerald Dorrer RSS

    Showing total for an expression in pivot table but not for details

      Hi,

       

      I'm trying to have an expression in a pivot table that is only displayed for the total, is this possible and if so, how?

       

      I have attached a screenshot with an example I have done in Excel.

       

      Across you have months with sales and costs for each month.

      Downward you have products.

       

      Now in the total to the right I also have a margin, but only in the total, not for each month - this is what I don't know how to do in QlikView, I don't seem to be able to display a total without having it there for each month too?

       

      Is this possible in QlikView?

       

      Thanks for any help!