Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created a table and pivot and both use the same measure. Why in my table do I get '0' values, yet in my pivot, I get '-' values?
Is there anyway to change the pivot from '-' to '0' please?
I have tried various things on the forum, but nothing works and wondered if there are other idea floating around to help.
My calculation is a simple: sum(sale)
Hi Thomas!
The only way I did found to show zeros in Pivot tables was to add rows with zeros (ie: sale=0) for each combination of dimensions (ie: customer, region, etc.) that not exists in data model.
Regards, Fernando
Try this expression: sum(alt(sale,0))
Might as well move alt(sale,0) to load script.. to keep it consistent.