partial sum

[upaliwije]

Hi,

I have a pivot table in my data table and output report is as follows

BRANCH	ITEM	SUM(QTY)	SUM(UNIT_PRICE)	(QTY)*(UNIT_PRICE)
ABC	Card Printers=165000	1	165,000	165,000
ABC	CPU=81000	1	90,000	90,000
ABC	Dot Matrix Printers=75000	0	75,000	0
ABC	High End Scan Kodak=128000	0	128,000	0
ABC	HP 401 Printers=45000	1	45,000	45,000
ABC	Scanners G3110=19000	1	19,000	19,000
ABC	TFT Panels=13000	1	13,000	13,000
ABC	UPS (3.0kva)=120000	0	120,000	0
ABC	UPS (650VA)=5000	1	5,000	5,000
ABC	Total	6	660,000	-

Here I do not get total in last column (qty)*unit_price) .Pls advise me where I have gone wrong

[jonathandienst · Accepted solution]

You should not be using 'naked' fields* - for the last column you need:

     Sum(QTY * UNIT_PRICE)

* fields not wrapped by one or other aggregation function (like Sum(), Max(), Count()...)

[sunny_talwar]

Working sample from your data using the expression provided by jonathan