Prob in pivot table

[nikhilgarg]

Hey,

In my attached application, for unknown region in pivot table there are shown 4 Names but when i select Desk as Unknown from list box it is showing only 2 names. Pls help.

Thanks

[buzzy996]

tht's because of ur expression defined like this =if(len(Desk) = 0 , 'Unknown' , Desk)

NAME: Y & U having null values tht's lenth it's assuming as 0 so u have 4 in desk (y,u,a,c)

[pokassov]

Hi!

It's because you use dimention expression instead of "Desc"

=if(len(Desk) = 0 , 'Unknown' , Desk)

[massimilianoruf]

Hi Nikhil,

this happens because the Dimension of the table is a Calculated Dimension and the values linked to "Unknown" are only  "a" and "c".

Massimiliano

[nikhilgarg]

So , what to do because when i click Unknown it should show Y and /U also

[nikhilgarg]

So , what to do because when i click Unknown it should show Y and /U also

[massimilianoruf]

You should modify the load script for delete null Desk values.

Load

...

if(IsNull(Desk),'Unknown',Desk) as Desk,

...

Hope this helps,

Massimiliano

[jonathandienst]

Then I suggest that you convert the nulls to 'Unknown' in the load script:

     LOAD

          ....

          If(Len(Desk) = 0, 'Unknown', Desk) As Desk,

HTH

Jonathan

[buzzy996]

i think ur using  mapping in script, so pls try this..

Mapping LOAD isnull(Name,'Unknown', Name) as Name

[nikhilgarg]

Hey,

THankx but i didn't get you. i am already using script that you suggesting