ZN, can not help me, in this case, as in the database there is no such information, when I create the table in Tableau, blank data, which do not exist. then I want to know how I can do that in these cells display a zero
I try to explain
X Y Z
A 1 1
B 1 1
C 1 1
So Tableau show me this, because in my Database dont have C in X
I hope u understand me better now...
Please upload a simplified version of what the data looks like in it's current format? Maybe in Excel? Then show us what you want the output to look like.
You may need to JOIN the current data set to a different data source which contains ALL values in order to get what you need, but I'm not sure yet.
I show u the problem, so where be write "Base 0", in the "Tipo de Factura (Factura Exentas)" I dont have information in the basedata about "Facturas Exentas" with "Keeper" and "TI"
The same for "Base 1" in "Facturas Normales, Electronica and Exentas"
In my basedata I have:
"Base" (If the sale is new or old)
"Tipo de Factura" (types of invoices)
"CCO" (cost Center)
so, I have the Sale with type of invoice and cost center (Base 1, Factura Electronica, Keeper (kind of Cost Center))
but I dont have in the basedata (Base1, Factura Exenta, and Keeper) Because de sale in this case don´t exist
And in tableau i want see this Empty cells with cero, is possible or should I change the basedata?
I hope that u can understand me now
Use ZN(LOOKUP(SUMA([Netox]),0)). The LOOKUP(aggregate,0) function returns Null if there is no value, then the ZN() turns that Null into a zero.
Thanks Jonethan!!!! the answer was great