4replies
-
Hi Ghada,
You can apply the column percentage in the Pivot as follows:
1. Analyze your Pivot table
2. Change the Scale of the column from the column options to Percent. This will show you the ratio of each value to the grand total of the revenue (in our example below)
3. To view it in percentage format, go to the Format tab and change the Format to Percent
4. Now you have the percentage of each value in the Pivot, you can also show the row & column totals to see the percentage per dimension too, as shown in the attached screenshots.