I need help concerning chart, specifically its total column. The case is the following:
I have two dimensions - quarter and year and I have expression sum(value). I have ticked the 'show total' for quarter in "Dimension Limits" tab, but what I am getting is one total column. I need to have different TOTAL columns for different years. The picture below represents what I am getting now. Is it possible to have separate totals for different years?
Thank you so much to all of you for your replies. They were very helpful for me as I am new to qlikview.
Raju, thanks for sharing your .qvw file. I wanted to have TOTALS at the end of the chart, not after each quarter, that's why I have modified it slightly (I deleted total from expressions and ticked the show total for quarter) and now it is exactly what I wanted. Thank you once again!