Is that what you wanted? I've tried to replicated the data set as per your screen shot. Let's assume this is your data set.
I've used LOD expression to calculated the Storedept and Gender wise Sales volume. Then used IF..ELSE to compare the sales volume for each gender. I've used multiple Shape marks cards to show the genders and their volume on labels and color using the calc fields.
Workbook attached for your reference. Let me know If you've any query.
Color.twbx 19.8 KB
3 of 3 people found this helpful
To get higher value as green and lower value as red you have to use a cal field.
I have created a formula based on sample superstore data.
You can use this kind of cal into your data.
Drop the cal field into the shapes and colour.
May be this will be helpful to you.
Thanks and Regards,
I'm really impressed from you ideau how to solve this challange. Thank you very much!
Kind regards from Berlin
thank you for your reply. It is not exactly what I wanted, but it is also very good advise.