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



      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!