Pivot Table Help?

Thu, 17 Apr 2014 11:46:36 GMT

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

Re: Pivot Table Help?

Thu, 17 Apr 2014 20:16:39 GMT

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

topic Pivot Table Help? in QlikView

Pivot Table Help?

Re: Pivot Table Help?