Hi,
i have a pivot table as per below, when I create a bar chart where is showing the value what I want.
After I insert a "Product" slicer in Pivot chart, the figure is showing "100%" instead of "44%" when i select only "Product A", the same situation as other selection.
is there a method to fix this problem?
Thank you.
No Legend and Filters used
Product (in Axis Category) %of grand total (100%), in Values
| a | 44% |
| ggg | 24% |
| nnn | 5% |
| ddd | 5% |
| aaa | 5% |
| bbb | 4% |
| mmm | 3% |
| eee | 3% |
| fff | 3% |
| sss | 3% |
| hhh | 2% |
| qqqq | 0% |
Hi terry
I don't have that issue (refer attachment)
Please create the bar chart using the above data and attach your workbook so that we can have a look at it.
Sunny
Hi Sunny,
please see the attachment as per request in regards to my query.
Thank you again.
Hi Terry
If you double-click on the Sum of % of grand total header of the PT (or right-click the PT and select Value Field Settings), under the Show Value As tab the Show values as should be No Calculation instead of % of Grand Total.
Hope this helps.
Cheers
Sunny
