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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Urgent - OWC Pivot Table Calculated Total doesn't work correctly 0
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot grand total 1
Calculated member 0
trouble in creating calculated total 3
Pivot Table Calculated Field 0
sort totals on multiple dimensions 4

Top