How to give common name in pivot table?

[Shubham_Deshmukh]

I am using pivot table ,this is what I am doing

What I want is,

Pls help

[its_anandrjs]

Create the bucket for this in load script or create the calculated dimension.

Load

*,

Mid(FieldName,3,1)  as XBucket

From Source;

On UI

Mid(FieldName,3,1)

Note:- suppress when null selection to be done

[Shubham_Deshmukh]

Sorry, I am not getting your 1st point.

I cant take calculated dimension at this stage in report.

[its_anandrjs]

From seeing your data i believe data should be

A(X)

B(X)

C(X)

Then i suggest in load script create the bucket Mid(FieldName,3,1)  as XBucket by this you get X from A(X), B(X) etc

Or else provide sample data.

[Shubham_Deshmukh]

A,B,C nad x are not the data , they are just names of expressions

[its_anandrjs]

Sample Data required then.

[prat1507]

so you can rename your expressions to A, B and C. Add a calculated dimension ='x' in the first field.

Regards

Pratyush

[Shubham_Deshmukh]

Ya it works, but my table is like

so name1 is possible but in same table what about name2?

[prat1507]

Is there any point for differentiation between A(name1) and A(name2)?

Regards
Pratyush

[Shubham_Deshmukh]

Ya, bcoz everytime I have to write it in bracket

i.e. A,B,C,D comes under X category. So I want to show like this.

But I am doing like A(X),B(X),C(X),D(X)