Skip to Content
0
Former Member
Jun 20, 2014 at 07:39 AM

How to add aggregation on multiple objects in a single webi table?

19 Views

Hi experts,

I recently face an requirement that show a report table in a specific format.

Let me show you in a simple example, let's say we have three dimensions and one measure. Product, Region, Quarter and Sales. When put these objects in an vertical table, it display data in this way.

Product Region Quarter Sales TV North Q1 37 TV North Q2 6 TV North Q3 4 TV North Q4 89 TV East Q1 81 TV East Q2 5 TV East Q3 32 TV East Q4 99 Mobile North Q1 13 Mobile North Q2 50 Mobile North Q3 95 Mobile North Q4 65 Mobile East Q1 58 Mobile East Q2 80 Mobile East Q3 76 Mobile East Q4 97

However, we expect to append some aggregation value in this table as this.

Product Region Quarter Sales TV North Q1 37 TV North Q2 6 TV North Q3 4 TV North Q4 89 TV East Q1 81 TV East Q2 5 TV East Q3 32 TV East Q4 99 Mobile North Q1 13 Mobile North Q2 50 Mobile North Q3 95 Mobile North Q4 65 Mobile East Q1 58 Mobile East Q2 80 Mobile East Q3 76 Mobile East Q4 97 TV All region Q1 TV All region Q2 TV All region Q3 TV All region Q4 Mobile All region Q1 Mobile All region Q2 Mobile All region Q3 Mobile All region Q4 All product North Q1 All product North Q2 All product North Q3 All product North Q4 All product East Q1 All product East Q2 All product East Q3 All product East Q4 All product All region Q1 All product All region Q2 All product All region Q3 All product All region Q4

As you see, we add "All region" and "All product" here, and combine them with real product, region and quarter value to show aggregations.

Can anyone tell me how to get such table in webi? Can we implement it simply in report level?

Best regards and thank you,

Ocean