3 Replies Latest reply: Jul 12, 2011 9:22 AM by Ester PERETS RSS

    Null in calculated dimension in table

      Hi,

      I have tryed to  calculated dimension in pivot table to put Null values when ever ther is Null in one Expression

      it lokes like that if(isnull(sales),null(),customer)

      I get only the customers that have sales but when ever I write other Expressions thay don't give the right results.

      is ther a way to write that dimension is customer and not only to put the customer name?

      or if ther is another solution to my problem?
      thanks,