Hello,
I want to get summary/total by dimension, but the data quite complicated because it's actually results from many other expressions.
This is the screen shot where the "Total KPI Value MD YDT YO" is my goal, but right now the result is zero. I want to get the result like the number in red.
The "Total KPI Value MD YDT YO" that i want is the summary/total from "KPI Value MD YDT YO" by "Sales Force".
But the "KPI Value MD YDT YO" is actually calculation results from many other expressions.
I also attach the QVW file to explain the calculation.
Really really appreciate if anyone could help me on this.
Thanks a lot