Log In
Register
Home
Active Member
April 28, 2021
Offline
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% |
VIP
Trusted Members
June 25, 2016
Offline
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
Active Member
April 28, 2021
Offline
Hi Sunny,
please see the attachment as per request in regards to my query.
Thank you again.
VIP
Trusted Members
June 25, 2016
Offline
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
