Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I am using pivot table and I need 0's to be populated not the blanks. If I select the option suppress zeros then both are going.
how to get 0's not the blanks.
_Priya
May be convert 0s to 0.00000001 and use dual function to display them as 0
try the below sample
Load * inline [
DIM,Sale
A,100
B,0
C,150
E,
F,200
G,0
H,
];
Create a straight table with DIM as dimension and below expression
Dual(
(sum(Sale))
,
sum(if(Sale=0,0.001,Sale)))
Now E and H which have null values will be hidden and B and G which have zero values will still be shown
If you really have blanks (nulls), can you just change the Null Symbol to 0?
let me try