Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using Show all values option to show all the null values and missing values by unchecking supress null values and zero values.
When Doing so everything is working fine but an extra column and row is getting added in the pivot table.How to avoid that?
Any Ideas?
Thanks in Advance
Can you share Screenshot of your pivot table chart.
Hi Murali,
Go to char properties and tick option "Supress When Value is Null"
Thanks,
AS
Hi PFA
Here I am using show all values by unchecking suppress zero values and Null Values.In doing that an extra column and row is getting added.
Can you tried to Select "Surpress When Value is Null" check box under dimension tab???
Null column might be occurring due to month missing in one of the data and same applied for other dimension as well.