Hello! I'm using this expression for calculaion of ABC analysis dimension for client base:
Aggr({<Client>}
If((Rank(Sum({<Client>} Delta),1)-1) / Count({<Client>} distinct total Client)< abc1, 'A',
If((Rank(Sum({<Client>} Delta),1)-1) / Count({<Client>} distinct total Client)< abc2, 'B', 'C')),
Client)
Works fine, but only in table with ont Dimension. Result looks like:
| Client | ABC | Sum(Delta) |
|---|
| Moris | A | 160000 |
| Doris | B | 15000 |
| Boris | B | 15000 |
| Norris | C | 10000 |
I want also to see, how ABC segmet changes from year to year for every client. Like this:
| 1 | 2012 | 2013 |
|---|
| Sum (Delta) | ABC | Sum (Delta) | ABC |
| Moris | 80000 | A | 5000 | C |
| Doris | 7500 | B | 80000 | A |
| Boris | 7500 | B | 7500 | B |
| Norris | 5000 | C | 7500 | B |
| | | | |
| | | | |
Just cant to get any result. Only to display ABC segment for current Year. If selected more than one year, ABC calculated for all amounts of Delta, ignoring the years. How to fix it?
