Row Sub Totals PIVOT are incorrect

Mon, 03 Nov 2014 03:47:58 GMT

I am trying to set up pivot calculation for employees with salary broken into Base and Allowances. Base is set f/nightly amount while allowances are dependent on hours contracted (the allowances amount requires prorata amount to be applied. I can get the calculation to perform correctly however the subtotals for each employee tally the base amount plus full time allowance amount.

Essentially the total for this example should be 1425.63 not 1427.11.

LastName	FirstName	WeekHrs	Salary	Base	Allowances	Total
AB	CD	24		$1,423.07	$2.55	$1,427.11

LastName	FirstName	WeekHrs	WageTypeCode	WageTypeDesc	Amount	Salary
AB	CD	24	11	M/F Basic Rate	1423.07	1423.07
AB	CD	24	2019	Laundry Allowance	4.04	2.55
					1427.11	1425.63

Any help will be appreciated

Re: Row Sub Totals PIVOT are incorrect

Gysbert_Wassenaar — Mon, 03 Nov 2014 10:11:47 GMT

Can you post a document that demonstrates the problem?

Re: Row Sub Totals PIVOT are incorrect

Tue, 04 Nov 2014 22:33:40 GMT

Attached is an example - I hope this helps

topic Re: Row Sub Totals PIVOT are incorrect in QlikView

Row Sub Totals PIVOT are incorrect

Re: Row Sub Totals PIVOT are incorrect

Re: Row Sub Totals PIVOT are incorrect