Hi,
I am using Excel 2013.
I have been looking everywhere to resolve this issue but to no avail.
I have a Pivot Table that looks like this :
Country | Data | Percentage |
UAE | 620 | |
| 130 | |
| 50 | |
Total for UAE| 800 | |
---------------------------- | ------------------- |
Omar | 200 | |
| 100 | |
Total for Omar| 300 | |
I need the Percentage to display per Country, for example ((620 / 800) * 100 = 77.5%).
The option to select % of parent row OR % of parent column is not there as this option has been grayed out.
Is there any other way to do this?
I am using Excel 2013.
I have been looking everywhere to resolve this issue but to no avail.
I have a Pivot Table that looks like this :
Country | Data | Percentage |
UAE | 620 | |
| 130 | |
| 50 | |
Total for UAE| 800 | |
---------------------------- | ------------------- |
Omar | 200 | |
| 100 | |
Total for Omar| 300 | |
I need the Percentage to display per Country, for example ((620 / 800) * 100 = 77.5%).
The option to select % of parent row OR % of parent column is not there as this option has been grayed out.
Is there any other way to do this?
