Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Data:
CORPORATE | Drug Combination | Value |
ABC | Aspirin | 2000 |
ABC | paracetamol | 3508 |
ABC | caffeine | 4567 |
CDE | caffeine | 7767 |
CDE | levodopa | 2345 |
POR | paracetamol | 6789 |
POR | Carbidopa | 5604 |
TUV | Aspirin | 1085 |
XYZ | caffeine | 3423 |
XYZ | Carbidopa | 1259 |
CVN | Abacavir/lamivudine | 9087 |
Where I want to achieve IPM, CVM & CurrentCompany
So I achieved IPM & CurrentCompany KPI simply by putting SUM(Value) & SUM({$<Corporate={'ABC'}>}Value) respc.
Now I want to achieve CVM - Drug Combination of Corporate ABC & available for other corporate also.
I need the below Output Corporate = ABC
DRUG Comb | IPM | CVM | CurrentC |
Abacavir/lamivudine | 9087 | 0 | 0 |
Aspirin | 3085 | 3085 | 2000 |
caffeine | 15757 | 15757 | 4567 |
Carbidopa | 6863 | 0 | 0 |
levodopa | 2345 | 0 | 0 |
paracetamol | 10297 | 10297 | 3508 |
Total | 47434 | 29139 | 10075 |
I tried using this expression - Sum({<[Drug Combination] = p({<CORPORATE = {"ABC*"}>})>}Value) but no success
You're really close with the expression you have... change it to:
=Sum({<[Drug Combination] = p({<CORPORATE = {"ABC*"} >} [Drug Combination]) >} Value)
Thanks,
Ben
Thank You @benvatvandata
It worked for me with an additional condition.
=Sum({<[Drug Combination] = p({<CORPORATE = {"ABC*"} >} [Drug Combination]),CORPORATE= >} Value)
You're really close with the expression you have... change it to:
=Sum({<[Drug Combination] = p({<CORPORATE = {"ABC*"} >} [Drug Combination]) >} Value)
Thanks,
Ben
Thank You @benvatvandata
It worked for me with an additional condition.
=Sum({<[Drug Combination] = p({<CORPORATE = {"ABC*"} >} [Drug Combination]),CORPORATE= >} Value)