Below mentioned table is a Circle wise Top 10 sales persons. When I apply for subtotal, below error is showing.
SP code (Unique ID), Name & Circle cannot be dropped.
How can we overcome this issue?
Aug 17, 2016 8:59 AM
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
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
Sep 1, 2016 6:52 AM
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