This content has been marked as final. Show 3 replies
Create a Union report as
Year - TG - DG - CS - '$'
Year - TG - DG - CS - '%'
Now in the second part, edit the measure formula to calculate percentage manually.
Like "SH"."Sales Facts"."Amount Sold" * 100.0 / REPORT_SUM("SH"."Sales Facts"."Amount Sold" BY ) . Replace Amount Sold measure by your measures ( TG , DG , CS).
Now put the measure labels in row section. Fourth column having values '$' and '%' in columns section and measures in the measures section.
Hope this helps.
Edited by: Maqsood Hussain on Jan 5, 2013 5:27 AM