calculated Dimension

[#1]

I am reading data from excel sheet, one of the column in excel have value as

A,

B,

C,

D,

E,

F

Now I want to add that column in pivot table as Dimension. But want only B,C,D value to be appear in that column in Pivot table. How i can achieve this with calculated dimension.

[perumal_41]

Hi Ramkumar ,

if possible Please upload sample application for reference.

Regards

Perumal A

[nilesh_gangurde]

In calculated dimension add the following script.

=if(FieldName <> A ,FieldName,if(FieldName <> E ,FieldName,if(FieldName <> F,FieldName)))

Where "FieldName" is the name of Column in which you have values such as A,B,C,D,E,F etc.

It Will Work for sure.

Regards,

Nilesh Gangurde

[#4]

Hi ramkumar,

you can add a calculated dimensions to the pivot-table (or to any other chart as well).

For Ex.: creating a calc dim out of field Type:

=if(  Type = 'B' or Type = 'C' or . . . , Type)

May be you need to build another condition using functions like wildmatch() etc.

HtH+

Roland

[CELAMBARASAN]

Try this

If(Match(Type,'B','C','D'), Type)