Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Pivot table . I need to show the blank values count. I can able to get the count. But my problem is I can able to make the blank values label as 'Default' in both horizontal and vertical. I an able to get in vertical. I need in horizontal? Is it possible. Please see attached.
Thanks.
As usual please provide sample data file or sample apps.
Please see attached.
use nullcount()
I need the label as 'Default' in horizontal also? where can I use nullcount()