Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have problems in my Pivot table. Expresion '1' and '4' are OK, it works. Expresion '1' and '4' are set analyse (Sum ({< [Division] = {'5' , '7'}, [Account] = {"602*", "601*", "604*"}, $(vSetMaxFinanceYear)>} [Incomes]) ) But I have problems in other expresions. I dont know :
- how to sum incomes in pivot table and then
- count rank of the customers.
Here is my resulted table, expression '1' '4' is working, other expressions not working.
Dim 1 | Dim 2 | Expr 1 | Expr 2 | Expr 3 | Expr 4 | Expr 5 | Expr 6 |
Cust. | Cust ID | Incomes Jan-Mai 2016 | % ratio | Rank 2016 | Incomes Jan-Mai 2015 | % ratio | Rank |
Windmol | WIND02 | 423846,19 | 21,84% | 1 | 523846,19 | 24,53% | 1 |
Ligumol | LIGU00 | 237746,80 | 12,25% | 3 | 287746,80 | 13,48% | 2 |
Brucmol | BRUC00 | 274481,94 | 14,14% | 2 | 275659,12 | 12,91% | 3 |
Bonamol | BONA00 | 168560,00 | 8,68% | 4 | 172459,69 | 8,08% | 5 |
Manrol | MANR03 | 157260,69 | 8,10% | 5 | 102360,12 | 4,79% | 9 |
Neusir | NEUS01 | 131550,80 | 6,78% | 6 | 91058,00 | 4,26% | 11 |
Stilmol | STIL00 | 91755,60 | 4,73% | 11 | 140250,23 | 6,57% | 7 |
Menzos | MENZ00 | 117615,86 | 6,06% | 8 | 174125,61 | 8,15% | 4 |
Amcmol | AMCM00 | 110858,16 | 5,71% | 9 | 100250,71 | 4,69% | 10 |
Lemomol | LEMO00 | 101077,49 | 5,21% | 10 | 112365,12 | 5,26% | 8 |
Etcimol | ETCI00 | 126234,04 | 6,50% | 7 | 155210,13 | 7,27% | 6 |
1940987,57 | 2135331,72 |
For ratio expression, try this:
Sum({<[Division] = {'5' , '7'}, [Account] = {"602*", "601*", "604*"}, $(vSetMaxFinanceYear)>} [Incomes])
/
Sum(TOTAL {<[Division] = {'5' , '7'}, [Account] = {"602*", "601*", "604*"}, $(vSetMaxFinanceYear)>} [Incomes])
For Rank expression, try this:
Rank(TOTAL Sum({<[Division] = {'5' , '7'}, [Account] = {"602*", "601*", "604*"}, $(vSetMaxFinanceYear)>} [Incomes]), 1, 1)