I want a report in pivot table view and i have tried to get that but i could not able to achieve that,Attached the screen shots how i have done.
Can you please give your suggestions?
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