Pivot Table Help?

[#1]

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

[#2]

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:

http://community.qlik.com/message/506853#506853