Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I charted a stacked bar and displayed Totals with help of second expressions ,this is working fine. How I implemented is When I use Quarter as Dimension, used SUM(TOTAL <Quarter> Production) as Expression. But please advise me what to use when the dimension is Drill down group (it has Quarter, Month, Day) , I need expression every time to calculate automatically as per drill level.
Hi,
Try below:
SUM(TOTAL <getcurrentfield(cyclicdrill/drilldown)> Production)
or
SUM(TOTAL <$(=getcurrentfield(cyclicdrill/drilldown))> Production)
HTH
Sushil
you can directly use sum(production) and keep the cyclic dimensions as you need
Nope It is not showing totals correctly
One thing I am sure is in second expression , we have use TOTAL qualifier as I wanna ignore 'Category' dimension as while summarizing. issue is using TOTAL with DrilldownGroup
Hi,
Try below:
SUM(TOTAL <getcurrentfield(cyclicdrill/drilldown)> Production)
or
SUM(TOTAL <$(=getcurrentfield(cyclicdrill/drilldown))> Production)
HTH
Sushil
Thanks Sushil, It worked final expression is
SUM(TOTAL <$(=GetCurrentField([>Drilldown]))> Production)
Can you tell me how you got a single total to appear? When I add a second expression, it shows the total on every bar and not just a single total at the top. Please advise? Thanks.