

November 26, 2020

I have some data in my pivot which goes to 50 rows with some values. I don't want all these rows to populate in my bar chart but only top 10 rows in terms of revenue. Can you please guide me how to format my bar chart to consider only top 10. For information, I have sorted the data accordingly in such a way the highest value is on top.
Thanks
G. Lakshmipathi

VIP

Trusted Members

December 7, 2016

Hello,
Have you tried using value filters in the PT so the table only shows the top ten?
https://www.myonlinetraininghu.....-by-values
Br,
Anders


November 26, 2020

Thanks for responding. Yes I found out myself later but I am having a different issue. When I select any value from the slicers and if the value is zero, then, the x Axis is not showing the desired result. Please find attached a screen shot for one combination of plant where the plant code is not showing wherever the value is zero. Can you please let me know how to make it visible the plant code even if the value is zero?
Thanks again
G. Lakshmipathi

VIP

Trusted Members

December 7, 2016

1 Guest(s)
