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

[paulyeo11]

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

[paulyeo11]

My QV Doc