Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I´m trying to display a pivot table that has a column "Quantity" with zero 0 in it.
When displaying the data through a table box I can see all the rows including thoose that have a 0 in column "Quantity".
But when diplaying the same in a pivot table all rows are shown except thoose that have 0 in column "Quantity"....
Please help me to display all rows.
Thanks in advance.
Hi.
Just toggle checkbox: Chart Preferences->Presentation tab->Supress zero-values
Hi!
Nice, but I still have a problem with theese values cause now I can see values as null that are acually not null...
When I click an article it says that the total is 2 464, but the expression says null....
Why do I get null when if it´s not? Or is it?
Thanks in advance.
Post your expression.
And the screenshot of data model (Table Viewer) if it's not a secret.