Sum of Rows in Pivot Table

[#1]

I've tried the format from the manual but I cannot get the correct totals in the pivot table.

All numbers are 37 times what they should be.

I've tried "sum(SALESPOTENTIAL)" and "sum(aggr(sum(SALESPOTENTIAL), CHANNEL, TYPE))" The results are the same with both.

Channel	TYPE	Sales Potential
A	Distribution Program	$101405900.00
	Multi-Family Use	$3700000.00
B	Distribution Program	$233100000.00
C	Distribution Program	$7992000.00
D	Commercial Use	$20491488.00
	Distribution Program	$74074000.00
	Multi-Family Use	$2131200.00
	Trading Opportunity	$4440000.00
E	Distribution Program	$38369000.00
	Multi-Family Use	$2664000.00
	Trading Opportunity	$13542000.00
F	Commercial Use	$740000.00
	Distribution Program	$47892800.00
G	Residential Quote	$444000.00
H	Distribution Program	$74495800.00
	Multi-Family Use	$4144444.00
I	Commercial Use	$31969628.00
	Multi-Family Use	$187598140.00
Total		$849194400.00

[sathishkumar_go]

Hi

can u attach ur application here?

Regards

Sathish

[#3]

Thank You, application attached

[johnw]

I don't have a solution, but if you make a list box of the opportunity ID, and select "show frequency", you'll see that every opportunity ID is duplicated 37 times. Why you have 37 rows instead of one for every ID, I don't know, but that's why your amounts are all 37 times too high. Normally when I see too many rows, it's because I did a join incorrectly, but in this case, none of your tables are joined, so that doesn't seem like the problem.

[#5]

Thanks, I'll try and figure out why that is