This content has been marked as final.
Show 1 reply

Re: Contribution Table
vikas mahajan Jul 31, 2015 3:06 AM (in response to Qianyu Zhuo)use this expression sum( Sales) / Sum(TOTAL sales)
1. Create a new pivot table with one dimension.
2. Add the following expressions:
Sales $ Sum(Sales)
Total Sales % Sum(Sales) / Sum(TOTAL Sales)
% Sales by
Country Sum(Sales) / Sum(TOTAL<Country> Sales)
3. On the Presentation tab, select the dimension and turn on Show Partial Sums.
4. On the Number tab, set the format for the first expression to Integer. Set the second
and third expression to Fixed to 2 decimals, and turn on Show in Percent (%).
5. Click on Finish to save the chart.
6. Rightclick on the Country field in the pivot table, and select Expand all from the
menu to show all the cities:
7. Resize the chart to see all of the values.
HTHVikas