How to show two bars based on same parameter (filter)
Hi All,
I have a data set with sales numbers. One of the fields determines in which reporting line we work. Lets say we have Reporting Lines A, B & C. I want to visualize the sales of these Reporting Lines in a special manner: I need to show sales of reporting line A and the sum of B & C.. so 2 bar's for 3 possible values of the field Reporting Line.
A = 1, B = 1, C = 1 --> bar1 = 1, bar2 = 2
A = 3, B = 1, C = 5 --> bar1 = 3, bar2 = 6
A = 5, B = 7, C = 3 --> bar1 = 5, bar2 = 10
what is the best way to do this? I was thinking of using a formula in my Measures definition... but can't seem to make anything come close to the expected values....
