This content has been marked as final. Show 3 replies
Did you try with Pivot table->Measures section column
Show Data As->Percentage of ->Column
I Tried Pivot table , show data as Percentage of -- (tried all option) nothing is showing the correct result.
Percentage of column is not the oprtion in your case. it is used in the single column, what is the percentage of single riw item,
do some reasearch on that, you will come to know.
You have done it correctly,
What you need do is to set the Aggreagation rule correctly.
click on the tortal amount click aggregation rule and keep SUM.
click on the tortal margin click aggregation rule and keep SUM.
click on the % margin click aggregation rule and keep default. (inside the column fx also it should be default)
it should work.
mark if works, helps,