Pie chart dimensions

[#1]

Dear All,

              In a pie chart how to limit the number of dimensions. For example I have some dimendions like AIX,Solaris,Windows,Linux........etc i want to limit the dimensions in my pie chart display

                                              How can we do this???????

[swuehl]

I guess you could use a calculated dimension, like

=if(match(DIMENSIONFIELD,'AIX','Linux'),DIMENSIONFIELD)

to filter AIX and Linux only.

[jonathandienst]

And on the dimension, set "Suppress when Value is Null"...

Jonathan

[#4]

Thanx swuehl/Jonathan,

                                  Its working perfectly,, but am getting the expression in pie chart how to hide that exp....

[swuehl]

I think you could use the label field on tab dimension.

[#6]

swuehl got it....thnx for your help

I have another requirement like i want to show the release verisons of AIX,Solaris,HP-UX...etc in different charts not in the same chart, in database we have 2 columns like OStype(AIX,Solaris...etc) and Release Version(5.1,5.2,5.3....for AIX) and(5.9,5.10,9...for sloaris).......etc. can i use in if condition all these versions separatly?????