Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am facing an issue regards to a pivot table.
In this Pivot Table Chart I want to add another column(Growth) which should have the calculation as summarized
The ACT UNITS of 2011 + ACT UNITS of 2012 ..
please find the screen shot ..
YTD Expr for your reference in the attached screenshot:
IF(ValueList('Units','%')='Units',
Num(Sum({<MonthOrder={"<=3"},[Product Type]={'Promoted'}>}[In-Market Units - CEU]),'#########.0'),
IF(ValueList('Units','%')='%',
Num(Sum({<MonthOrder={"<=3"},[Product Type]={'Promoted'}>}[In-Market Units - CEU])/Sum({<[Product Type]={'Promoted'}>}[In-Market Units - CEU]),'##%')))
any help would be greatly appreciated
Thanks & Regards
Helen
Message was edited by: Helen Betty
Helen,
I'am afraid, that with your conditional expression you are not able to use Partial Ssms.
Here you may find some idea how to resolve your problem: