What should be expression for gauge with two variables for attached data ?

[shekhar_analyti]

Hi All ,

I want gauge chart which calculates % of drug(selected) sale in the selected country .

If user does not select any country then its should give % sale of that drug globally (which means in all countries present in data)

Thanks

Shekar

[shekhar_analyti]

Is this not possible stalwar1‌ , lironbaram‌

[sunny_talwar]

Can you share expected output based on few selections?

[shekhar_analyti]

' If user selects Ibuprofen then its % sale should be 172.69+1208.64+2874.43 divided by Total Sale of all the
drugs across country . But if user further selects Thiland then it should show sale % as
2874.43 divided by 172.69+1208.64+2874.43 ' .

Done that selection in attachment

[sunny_talwar · Accepted solution]

May be this:

=If(GetSelectedCount(Country) = 1,

Sum(Sale)/Sum({<Country>} Sale),

Sum(Sale)/Sum({<Drug, Country = p(Country)>}Sale))