Top 3 sum of Straight table

[sijojoseph22]

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

[Anonymous · Accepted solution]

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

[sunny_talwar]

Are you trying to achieve one of the two below?

If yes then PFA

[sijojoseph22]

Thanks

[awhitfield]

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

[QS21]

unable to open QVW, could u paste the logic in comments pls..