Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need to full fill zero as sample
Need like this
Check the attached
Hi,
Another way is to do it on pivot table attached screenshot for reference:
Regards,
Mayank
My customer need to present in chart.
For that you need to create rows with null values for every non-existing combination of the key.Then the sum on null should work and return 0 .For this just check show all values for dimensions.
Regards,
Mayank
already check but it not work.
What are your dimensions as per the excel?
Hello!
Check "Show Zero Values" on Presentation tab. Should work.
Unchecked Suppress Zero-Values, Suppress Missing.. under presentation tab.
And checked Zero on Bars...
Not working
uncheck suppress missing