topic Re: How to add Total Exp Amount contribution % for my pivot table ? in QlikView

How to add Total Exp Amount contribution % for my pivot table ?

paulyeo11 — Sat, 15 Jun 2013 14:17:17 GMT

Hi All

My pivot table Expression as below :-

(

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[Reporting Code] = {

">=1<=

}

, month = ,year=>}[Amount])/1000)

I like to compute the total sales contribution % , I aware i need to like some thing like below :-

(

Sum({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[Reporting Code] = {

">=1<=

}

, month = ,year=>}[Amount])/1000)

/

(

Sum(TOTAL({$<YearMonth = {"<=$(=Date(addmonths(Max({$}[YearMonth]),-0),'YY MMM'))"}

,[Reporting Code] = {

">=1<=

999"

}

, month = ,year=>}[Amount])/1000)

)

But it does not work , hope some one can advise me.

Paul

Re: How to add Total Exp Amount contribution % for my pivot table ?

paulyeo11 — Sat, 15 Jun 2013 14:20:16 GMT

My QV Doc