Pivot Table showing data for Previous years after grand total

[#1]

Hi Everyone,

Is it possible to show data for previous years after grand total like in the image below:

I need to show only the total for previous years in the same report.Lets say the selected year is 2016-17.

Is it possible? If yes, please suggest ways to achieve the same.

Thanks in advance.

Jemimah

[jonopitchford]

Hi Jemimah,

Yes it should be sort of possible using the dimensionality() function on a pivot chart and perhaps playing around with column widths and 'indent' in the style tab. Its hard to give an exact answer without looking at an example of your data structure and .qvw.

here is a example of using dimensionality to customise pivot tables:

Qlikview Subtotaling Customization |

Qlikview Subtotaling Customization: Part 2 |

thanks

Jonathan

[lironbaram]

hi

if you'll use year as the first dimension, than you'll be able to achieve this

easily