Totals not showing in the pivot table

[#1]

Hello -

I have a pivot table with sales, % of sales and I use % of sales * Price to calculate the Price $ field. The calculated field doesn't show the totals in the pivot table. I am not sure how to show the totals. Also, if I collapse the lowest level, the totals are not showing.

here are the details:

Product Line ID	ref	T12	% of Sales	Price %	([Price %])*AdjBase	AdjBase
2300	AMERICAS GROWTHDELFIELDUSCHAINSNON STRATEGIC ACCOUNTS	4,308,866	54%	0%	0	4,596,858
2300	AMERICAS GROWTHDELFIELDUSDEALERSNON STRATEGIC ACCOUNTS	28,261,957	29%	1%	301,509	30,150,902
2300	AMERICAS GROWTHDELFIELDUSDISTRIBUTORSNON STRATEGIC ACCOUNTS	3,051	0%	1%	33	3,255
2300	AMERICAS GROWTHDELFIELDUSFACTORY AUTHORIZED SERVICERSNON STRATEGIC ACCOUNTS	33,769	67%	0%	0	36,026
2300	AMERICAS GROWTHDELFIELDUSINACTIVENON STRATEGIC ACCOUNTS	6,836	8%	0%	0	7,293
2300	AMERICAS GROWTHDELFIELDUSOTHERNON STRATEGIC ACCOUNTS	431,931	13%	0%	0	460,800
2300	Total	33,046,410	30%	-	-	35,255,134

The total line doesn't show totals for column ([Price %])*AdjBase which is a calculated field.

I am attaching my sample.

What I am missing from my formula?

Thanks for all the help.

[SunilChauhan]

see the attched file.

you need to apply some function like sum,only inside the expression

see the attached file

[#3]

I tried that but the total doesn't add up because you are adding up % column first so rather than just adding up the column with calculation, it first adds up 1% which is not correct. Is there any other way to get the correct total?

The total for the column should be 301,542 not double the amount

Thanks

Product Line ID	ref	T12	% of Sales	Price %	([Price %])*AdjBase	AdjBase
2300	AMERICAS GROWTHDELFIELDUSCHAINSNON STRATEGIC ACCOUNTS	4,308,866	54%	0%	0	4,596,858
2300	AMERICAS GROWTHDELFIELDUSDEALERSNON STRATEGIC ACCOUNTS	28,261,957	29%	1%	301,509	30,150,902
2300	AMERICAS GROWTHDELFIELDUSDISTRIBUTORSNON STRATEGIC ACCOUNTS	3,051	0%	1%	33	3,255
2300	AMERICAS GROWTHDELFIELDUSFACTORY AUTHORIZED SERVICERSNON STRATEGIC ACCOUNTS	33,769	67%	0%	0	36,026
2300	AMERICAS GROWTHDELFIELDUSINACTIVENON STRATEGIC ACCOUNTS	6,836	8%	0%	0	7,293
2300	AMERICAS GROWTHDELFIELDUSOTHERNON STRATEGIC ACCOUNTS	431,931	13%	0%	0	460,800
2300	Total	33,046,410	30%	-	301,542	35,255,134

[jolivares]

First you have to understand that QV works grouping data, so it means that always you have to group all your data in order to present in a table.

In your sample you are  mixing data grouped and ungrouped.  Try to make all the calculations directly in the table and see what happens.

In case you need more help post a new example with all the formulas.

[#5]

Juan -

What do you mean by ' Try to make all the calculations directly in the table and see what happens'? I am not sure how I can do that. Please let me know.

Thanks

[jolivares]

Try to calculate the price% and so on...