Sum in pivot table, percental ratio and rank of the customers

[jozisvk11]

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

[sunny_talwar]

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)