Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello guys, a quick question.
I am searching a way to sum up the below Measure where:
code is distinct AND H Level = CDI AND TIME = mtd.
code | H Level | Team | RM | TIME | product | Measure |
a | CDI | A | A | mtd | 1 | 10 |
a | CDI | A | B | mtd | 2 | 10 |
a | CDI | A | C | ytd | 3 | 10 |
b | CDI | A | A | mtd | 1 | 10 |
b | ACCOUNT | A | B | mtd | 2 | 10 |
b | CDI | A | C | ytd | 3 | 10 |
So expected to get a result:
cdi | pfa |
a | 10 |
b | 10 |
I have found that aggr - sum function with distinct creates a temporary table with unique values but I could find a way to combine aggr - sum with set analysis for H level and TIME .
Thanks in advance
sum({<TIME={'mtd'},[H Level]={'CDI'}>}distinct Measure)
This does not result in Distinct Codes , we need aggr sum for this but i cannot find a way to use aggr sum with above set analysis f.e
F.E if you have 2 codes with same measure as above is will result in keeping only one code (f.e a code)