on 04-11-2016 8:47 AM
Hi all,
I have got a dimension Categories with values A, B, C and D and I need to show in the categories axis of a bar chart the values: A, B, C, D, A+B, C+D.
Could I create a new dimension which contains A, B, C, D and two new values A+B and C+D?
Thanks,
Jonás
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can you give some sample data and the output required
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Your requirement is similar to the attached link https://scn.sap.com/thread/3873035
You need to get the values for A+B,C+D at the query level itself by using union operator. Please check my comments in attached post.
You can try having multiple queries one for individual values and 2 more for your aggregated values. merge dimensions from all these queries and use in the report.
there are some workarounds people suggests like having like overlapping charts one for individual values and one for summarized values.
but all these are workarounds using formatting not straightaway solutions.
So choose the one optimum for you
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.