Hi,
The users what to add in ‘groupings’ to a pre-existing bex query. Within this query there is already a key figures structure. To provide the groupings I created another structure which provided all of the options within ‘Group 1’ like figure 1.
Figure 1:
Group 1
Key Figure
Jan-12
Feb-12
Mar-12
Apr-12
May-12
Jun-12
All Countries
Actuals
2900
3100
3450
2800
3200
3350
Top 15 Countries
Actuals
1900
2000
2300
1800
1900
2300
Top 40 Countries
Actuals
2300
2300
3000
2300
2300
3000
Company
Actuals
2300
1200
1200
1485
1200
Key Competitors
Actuals
1100
1300
1100
1300
1100
1300
Others
Actuals
900
1100
1300
900
1100
1300
However they want to be able to compare the groups. For example how is the company doing in the top 15 countries compared to the key competitors. The report needs to look like figure 2.
Figure 2:
Group 1
Group 2
Key Figure
Jan-12
Feb-12
Mar-12
Apr-12
May-12
Jun-12
All Countries
Company
Actuals
1000
1100
1150
1000
1100
1150
Key Competitors
Actuals
900
1100
1300
900
1100
1300
Others
Actuals
1000
900
1000
900
1000
900
Top 15 Countries
Company
Actuals
100
110
115
100
110
115
Key Competitors
Actuals
90
110
130
90
110
130
Others
Actuals
100
90
100
90
100
90
Top 40 Countries
Company
Actuals
250
275
250
275
Key Competitors
Actuals
225
275
325
225
275
325
Others
Actuals
250
225
250
225
250
225
It is not possible to add in another structure and hierarchies are not an option either. Anyone have any suggestions has to how two groups can be provided?
Thanks
Sara