query

[Nitesh_Jaiswal]

i want Total while Having value 0 to Th sale

 SO As In 3rd Line IT is showing the value 0 But But I want Total Value As 1250

[kfoudhaily · Accepted solution]

if I understand well your question, here is the expression to use:

if(Dimensionality()=0,sum(sale),if(sale>0,0,'N'))

please don't forget to accept response if it's ok for you.

regards,

[Nitesh_Jaiswal]

thanks for the solution this is what we needed. but i have one q as can we use only those two table one is dimension which is zone and and another that expression table only  , i dont want to show that sum(sale) row.

[Nitesh_Jaiswal]

thanks for the solution this is what we needed. but i have one q as can we use only those two table one is dimension which is zone and and another that expression table only  , i dont want to show that sum(sale) row.

[kfoudhaily]

i'm not sure I understand, can you develop a bit more?

regards,

[Nitesh_Jaiswal]

i want like this but whenever i remove that sum (sale)i get this

[Nitesh_Jaiswal]

i want thisbut i get this