on 03-30-2016 1:38 PM
Hallo Christina
You could create a variable to group them, example:
=If([Product] InList("Product A";"Product B";"Product C";"Product D")) Then "Group 1" ElseIf([Product] InList("Product E";"Product F")) Then "Group 2" Else "Group 3"
And then you could change the coloring according to the group variable
Regards
Antonette
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Cristina,
As mentioned by Antonette, you can create a group variable based on the product names and while creating the Rule for coloring you can use this variable and let the original columns in the table as it is. you should not change anything in the table.
This grouping is only to create the alert/conditional rule.
Apply the rule on the columns you need
Thanks, it’s coming as expected. However, I have 1 issue with Percentage column. I am dividing Row totals (sum of Products) by Grand Totals (Total Products), for Ex: 1500/16879=.8 should appear, but I am getting 1 for al rows, here is the formula =Sum([Product])ForEach ([GROUP])/ =Sum([Product]) GROUP is the group mentioned by Antonette
Hi,
You are example says you want to divide each row total with grand total i.e 1500/16...
where as your formula says you want to divide group total by grand total..
For fist scenario use =Sum([Sales revenue] )/Sum([Sales revenue] In Block )
For second scenario you can use =Sum([Sales revenue] In ([Group]))/Sum([Sales revenue] In Block )
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.