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?