Pivot table Calculated total

F

frog314

I created calculated total:
iif(isempty([Measures].[On Sale]),null,iif([Measures].[On
Sale]<>0,null,val("0")))
when I put it on Data Area I cannot see any values
but when I put it on Data Area for example with [Measures].[On Sale]
everything is okay.

Do you have any ideas what’s wrong?

Regards
 
Top