You can add a new Show Partial Sums in the Presentation tab of the chart properties to the field FYEAR, or create a new expression, but that will make your chart different. Subtotals are referred to dimension values, you cannot mix them, or "insert a new line" as the expressions make sense related to the dimensions.
Hope that helps.
Try adding the totals to the table:
LOAD [Item Final Group],
FROM YOY_TOTAL.QVD (qvd);
load 'TOTAL' as [Item Final Group], 'TOTAL' as MONTH, FYEAR, sum(AMOUNT) as AMOUNT, sum(QTY) as QTY
Resident T1 group by FYEAR;
See attached example.
Sales Y-on-Y Live.qvw 143.2 K
I don't understand what you mean. The totals are recalculated on every reload so they are always correct. Just don't use the grand total in the chart (disable partial sums on the first dimension) since you've already calculated your own in the script.
I'm afraid it's either this solution or something far more messy (if anything at all). As Miguel explained you can't mix subtotals the way you want.
The thing is for every summary that the user want I need to create each of them separate chart/pivot table.
Becuase if the user wanted to select only particular month then my computed grand total on reload will already be wrong.
For illustration purposes please see attached screenshots.
Thanks again and I think I will just leave with my current workaround.
Table Comparison.jpg 324.4 K
I donnw Whethr i have understood this completely...and can't see ur Qvw file as m using my personal edition........but if its only regarding getting the subtotals on yearly basis....then y not try pivoting the chart and shifting the Year column towards the left and the Group column towards right
Then the subtotals can be seen on Yearly basis if you take year as dimension and the grand total too as you also have mnth as dimension.
this was jsst a simple suggession, ignore it.. if the desired result is smthng different.