Null in calculated dimension in table

[ester_pr]

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,

[erichshiino]

I belive it's easier if you post some sample data.

... What kind of differeces did you find?

maybe your dimension could be:

aggr( if( sum(Sales) <> 0, customer), customer)

Or... you could use an if on each expresson:

= if( sum(sales)<>0, sum(budget))

Hope this helps,

Erich

[ester_pr]

Thank you Erich you have been very helpful

Ester

[ester_pr]

Hi,

naw I am trying to exclude in gauge tha sales to which there are no guals, but when ever i do'nt choose customer the sum is for all, including these with no gouls

the same for chart

I have tride aggr but stil, in sum all does'nt work

tanks,

Ester