That works (thank you!), however i have a filter [Product_Id] and when i filter a specific product, the calculated field still returns values as if it's not filtered. If there a way for the calculated field to take into account the filter?
I have another question - The attachment i sent you has the two values stacked. I want the bars to be unstacked, but not side-by-side, rather one in front and the other behind it. Can you help me on this? (Do i have to open a new discussion for this?)
1 of 1 people found this helpful
For first one: Put your filter on context like this
you can create separate calculated fields for Consumer and Corporate segments quantity and using dual axis you can achieve this, See below screenshot.
hope this help.
SUPERB ! 2 for 2
Glad it worked kindly mark my replies as correct/helpful so that this thread gets complete and its get hide from unanswered list.