This content has been marked as final. Show 6 replies
try create new dummy column with following formula:
and use it instead of PivotTable duplicate layer with "Show Data as Percent of Row" feature
"Sales"."Sales Amount" / SUM("Sales"."Sales Amount" BY 1) * 100
Looks very simple, many thanks for the solution.
Marked it correct
Can you help me once again,
There is one more measure named Sales Amount YTD Prior.
And i want one more variance column for the above measure.
I tried the formula you have given
"Sales"."Sales Amount YTD Prior" / SUM("Sales"."Sales Amount YTD Prior" BY 1) * 100
But it didnt worked, can you please advice.
Can you post here physical query generated by your answer?
I can provide Physical SQL but it will be very huge since the report is too huge, and there is outer joins included in the query...
Anyways please clarify this, in the formula we are using "BY 1", does this mean order by "Customer" (1st column). If so,i am using Order by 1 for two variance columns will that work?
Edited by: raj p on Jan 23, 2013 12:08 PM