HELP WITH PIVOT - TOTALS AND DIMENSIONALITY

[#1]

I needhelp  with totals in a pivot table. Iwant to obtain the data of column number 3, but I don’t know how to do it.

I need tosee the numbers of bills of each salesman classified in distinct groups.

Any suggestion?THANKS!!!

		1		2		3
R.Salesman	R.GrupoVtoCobro		count(distinct  idRecibo)		count( distinct idRecibo) / count(distinct  total  idRecibo)			????
Salesman1	0 Antes del Vto		80		0,38%			2,95%
Salesman1	01 a 15 días		453		2,17%			16,72%
Salesman1	16 a 30 días		273		1,31%			10,08%
Salesman1	31 a 45 días		557		2,67%			20,56%
Salesman1	46 a 60 días		501		2,40%			18,49%
Salesman1	61 días o mas		845		4,06%			31,19%
Salesman1	Total		2709		13,00%			100,00%
salesman2	0 Antes del Vto		27		0,13%			1,14%
salesman2	01 a 15 días		293		1,41%			12,36%
salesman2	16 a 30 días		365		1,75%			15,40%
salesman2	31 a 45 días		420		2,02%			17,72%
salesman2	46 a 60 días		350		1,68%			14,77%
salesman2	61 días o mas		915		4,39%			38,61%
salesman2	Total		2370		11,38%			100,00%

[kaushiknsolanki · Accepted solution]

HI,

    Try this.

     count( distinct idRecibo) / count(distinct  total<R.Salesman>  idRecibo)

Regards,

Kaushik Solanki