Calculated expression in pivot doesn't give me totals

[#1]

I have created a pivot table with detail, ref as the lowest level. The problem is that my 'Price' field is a calculated expression which multiplies price % * Adjusted base. When I show detail in the pivot, the amount shows but no total. when i go a level up nothing shows. How can I show the total for calculated expression so even when I click on 2360 only and hide ref column, my detail will stay in place?

Thanks

[ecolomer]

Can you attach QV file ?

[qlikoqlik]

Hi

Can you please post your expression as it is working for me

Thanks and regards

Padma

[#4]

This is in the pivot table though right?

[#5]

Sure attached please find the sample.

Thank you!

[#6]

Could you post your example where total price is in a pivot table?

I attached my sample above.

Thank you

[ecolomer]

I think the problem is not of formulas

Please review the fields values ​​with Price

[#8]

Ok I am confused. I just want the total for 'Price' column can I get that? Not sure what is wrong with the column. Can you attached the example you just showed in.png please

[ecolomer]

Yes, here are

[#10]

Thank you but now how do I get the total into my pivot table for the column Price? that's what I really need.

So I want to see the following:

Product Line ID	T12 June YTD 2014	RE2 Allocated	Adj Base	Adjusted Base	Price %	Price $	Price
2300	33,836,051	36,097,552	117,835,965	117,835,965	-	0	-
2360	0	0	964,266	0	0%	0	0
2360	2,004	2,138	757,399	2,910	0%	0	0
2360	6,997	7,465	8,465,272	113,563	0%	0	0
2360	489,066	521,754	102,488,560	96,098,595	1%	0	960,986
2360	0	0	1,026,840	0	1%	0	0
2360	1,791	1,910	87,104	299	0%	0	0
2360	21,728	23,180	3,550,884	147,923	0%	0	0
2360	521,586	556,447	117,340,326	117,340,326	-	0	960,986
2345	183,374	195,630	113,702,337	113,702,337	-	0	-