Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
My QV Doc