This content has been marked as final.
Show 3 replies
-
1. Re: Top 10 Dynamic subtotal
Yuriy FalAug 17, 2016 8:59 AM (in response to Roger Hawaibam)
Hi rogerf,
May I ask: what kind of Subtotals are you expected to see,
taking into account [SP Code] claimed to be Unique ID? Just curious.
Yours,
Yuri
-
2. Re: Top 10 Dynamic subtotal
Roger Hawaibam Sep 1, 2016 6:21 AM (in response to Yuriy Fal)Hi Yuri,
Sorry for delay in revert.
What I wanted is the subtotal of both GWP & % Share of GWP of Top 10 SPs. just below the bars.
Thanks,
Yours
rogerf
-
3. Re: Top 10 Dynamic subtotal
Yuriy FalSep 1, 2016 6:52 AM (in response to Roger Hawaibam)
So you just want Column Grand Totals
for your Top 10 [SP Code] by SUM([GWP]) ?
This is as simple as placing [SP Code] on Filters
and choose ALL --> Top 10 by SUM([GWP]).
Then show Column Grand Totals.
Please make sure every other dimensions
on Filters are in Context.
Yours,
Yuri