Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using pivot table ,this is what I am doing
What I want is,
Pls help
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
Sorry, I am not getting your 1st point.
I cant take calculated dimension at this stage in report.
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.
A,B,C nad x are not the data , they are just names of expressions
Sample Data required then.
so you can rename your expressions to A, B and C. Add a calculated dimension ='x' in the first field.
Regards
Pratyush
Ya it works, but my table is like
so name1 is possible but in same table what about name2?
Is there any point for differentiation between A(name1) and A(name2)?
Regards
Pratyush
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)