Skip to Content

Summarising structure in Webi

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2016 at 11:59 AM

    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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.