Problem with subtotals in a pivot chart

[geogou1973]

Hello,

I have the following formulain a pivot chart.

IF(PHASE='PHASE1',sum({<SALES_DATE={'>=$(=start_date)<=$(=end_date)'},FORMAT={'3_HYPFL','1_SUPER','4_PROXI','2_HYPMI'}-{'FRANC'},SKLA={'SKLA'},STORE_SKLA={'STORE_SKLA'} >} SALES_QTY),

IF(PHASE='PHASE2',sum({<SALES_DATE={'>=$(=start_date2)<=$(=end_date)'},FORMAT={'3_HYPFL','1_SUPER','4_PROXI','2_HYPMI'}-{'FRANC'},SKLA={'SKLA'},STORE_SKLA={'STORE_SKLA'} >} SALES_QTY)))

When i check the show partial sums in the presentation for the field PHASE the totals do not show for the phases.

I think this is happening because i have in the formula if condition and no sum(if...)

How can i convert the formula in order to have the totals for the phase in the top.

I have to mention that i want to show and other subtotals for other fields.

Thank  you in advance.

[sunny_talwar · Accepted solution]

What all your dimensions? Try this:

Sum(Aggr(

IF(PHASE='PHASE1',sum({<SALES_DATE={'>=$(=start_date)<=$(=end_date)'},FORMAT={'3_HYPFL','1_SUPER','4_PROXI','2_HYPMI'}-{'FRANC'},SKLA={'SKLA'},STORE_SKLA={'STORE_SKLA'} >} SALES_QTY),

IF(PHASE='PHASE2',sum({<SALES_DATE={'>=$(=start_date2)<=$(=end_date)'},FORMAT={'3_HYPFL','1_SUPER','4_PROXI','2_HYPMI'}-{'FRANC'},SKLA={'SKLA'},STORE_SKLA={'STORE_SKLA'} >} SALES_QTY)))

, DimensionNamesHere))

[geogou1973]

It is OK. Thank you very match