Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have pivot as below
Country State Sales
USA NJ -
CT -
DE -
DC -
Country and State are dimension and Population is expression.
Now when no sales for all the States, still I want to see pivot chart as above with value 0 for Sales, rather than shrinked.
Is there any way. I appreciate your help
Thanks
Hi Satish
In order to show zero values in a pivot table, you need to do the following:
1. Show All Values for ALL the dimensions in the Dimension tab
2. Clear the Suppress zero Values from the Presentation tab.
Check the attached qvw.
Let me know if this works for you and if you need anything else 🙂
Regards
Agis
Hi
Uncheck 'Suppress Zero Values' on the presentation tab.
HTH
Jonathan
Hi Jonathan
It works but dimension are missing. This is just example but in my case there 100s of lines and I need to see all those even zero values.
Thanks for your great help
Hi Satish
In order to show zero values in a pivot table, you need to do the following:
1. Show All Values for ALL the dimensions in the Dimension tab
2. Clear the Suppress zero Values from the Presentation tab.
Check the attached qvw.
Let me know if this works for you and if you need anything else 🙂
Regards
Agis
Hi Agis
I appreciate your efforts, I do not see any attachment here.
Please attach again,
Thanks
Now???
Is this what you wanted Satish? Is there anything else I can do to help you?
Could you please mark the answer as Correct if this is what you were looking for?
Thanks
Agis
Hi Agis
Sorry for late, your suggestion works perfectly.
I appreciate your interest and time
Thanks
Satish