HI All,
I have requirement-
I have two Crosstabs in webi
One is detailed and other one is summary of the first cross tab.
The rows and column of the crosstab is made up of bex Structure-
like below
A1 A2 A3 B1 B2 B3
A1 1 1 1 1 1 2
A2
A3
B1
B2
B3
Z1
Z2
Z3
Now I have to achieve the below summarized crosstab using the above cross tab..
A B C D
A
B
C
D
Z1
Z2
Z3
I have created two variables to get A from A1 A2 A3 and B from B1 B2 B3 and so on..
But the key figure is not getting summarized. shows multivalue error.
Can any one suggest how can I get the Keyfigure working to get the summary data.
PS: this summarization should happen only for A B C and D.. Z1 Z2 Z3 should remain same in summary cross tab..
Many Thanks,
Swapna
Hello Swapna,
In that case you need to use String Function as
=Substr([ColumnData];1;1)
This will aggregate all A1,A2 and A3 to A similarly for B,C and D and for Z you can check an if condition as
=If Substr([ColumnData];1;1)="Z" then [ColumnData] Else Substr([ColumnData];1;1)
Regards
Niraj
Add a comment