Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need go get the sum of Top 3 in a straight table. Currently it is showing the total.
Attached the sample. Please could you advise?
Thanks,
Sijo
Take a look at the attached file.
I've limited to 3 lines in dimensions limits, and changed the accumulate properties for the expression.
Hope it helps.
Gabriel
Take a look at the attached file.
I've limited to 3 lines in dimensions limits, and changed the accumulate properties for the expression.
Hope it helps.
Gabriel
Are you trying to achieve one of the two below?
If yes then PFA
Thanks
Hi Sijo,
1. Remove Max Number from Presentation
2. Dimension Limits - show only 3 largest - Untick Show Others
3 Expressions - change Total Mode to Sum of Rows
regards,
Andy
unable to open QVW, could u paste the logic in comments pls..