Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 10 brands,everyday frequently 6 brands will sell out of 10 brands.In my pivot table it is showing only 6 brands which is having values.
But i want to show other 4 brands which is not selled in that day along with this 6 brands.
how can i show this 10 brands in my pivot table with or without values.
Can anyone have idea about this...
regards,
baru
Hi Baru
Inthe presentation tab deselect the supress zero values check box
and in dimension tab donot select supree when value is null
tthen it diplay null values also
Hi Khushi,
Thanks for reply,
I already did this, but it is not displaying.
Any other solution for this..
regards,
baru
hi baru
Try using isnull() function
i think u need to provide more info., any other dimensions/exprs in ur chart ?
can u provide a sample app?
Hai Baru,
Pls See The Attachment I hope It does helps you
Regards,
Chandu