Pivot table total Column from only one dimension.

[#1]

I am fairly new to qlikview so hopefully this question isn't too dumb. I have created the pivot table shown above. I would like to add another totals column next to "Total 1" which is calculated from only the "Division Dimension" so that it looks like the picture below. The goal is to show the total from the year before. I tried using total<Division> but this will only show the correct total if one division is selected and the value is also displyed under every month column as well. I would like only the total of that calculation to be displayed.

Thanks!!

Marc

[Gysbert_Wassenaar · Accepted solution]

Use a calculated dimension like aggr(sum({<Year={"$(=only(Year)-1)"}>}Value),Division)

Year, Value and Division should be replaced with the correct names for your data. You also need to have data for more than one year in your data (should be obvious if you want to show previous years totals). And you need to select one year or the calculated dimension won't return values.

You'll probably have to drag the new calculated dimension in the right place (just to the right of the first column).

[#3]

That worked perfectly. Thanks for the help!!