Insert Sub Totals

[#1]

Hi,

I need some sub totals to straight table chart. I need some totals split by CSR and Customer Code.

I have highlighted the results I need in yellow and would like to know how I "break" the report up. It is pretty easy to do in crystal as you group the csr and then add another group for the customer and then add the totals in the group footer. Assume this can be done in Qlikview. Any help would be gratefully received

CSR	Sales Order Num	Sales Required Date	Sales Order Date	Item Code	Sales Ordered Quantity	Sales Outstanding Quantity	Sales Order Status	Customer Code
AE	137809	01/03/2016	24/02/2016	ITEM2	1500	1500	Authorised	B2029
AE	137809	01/03/2016	24/02/2016	ITEM3	1500	1500	Authorised	B2029
AE	139409	19/08/2016	29/07/2016	ITEM4	100000	0	Authorised	B2029
AE	139409	19/08/2016	29/07/2016	ITEM5	100000	0	Authorised	B2029
					203000	3000
AE	139198	22/07/2016	06/07/2016	ITEM6	1000	0	Authorised	B2030
AE	139198	22/07/2016	06/07/2016	ITEM7	1000	0	Authorised	B2030
AE	139198	22/07/2016	06/07/2016	ITEM8	1000	0	Authorised	B2030
AE	139476	16/09/2016	05/08/2016	ITEM9	50000	50000	Authorised	B2030
AE	139476	16/09/2016	05/08/2016	ITEM10	50000	50000	Authorised	B2030
AE	139477	16/09/2016	05/08/2016	ITEM11	50000	50000	Authorised	B2030
AE	139477	16/09/2016	05/08/2016	ITEM12	50000	50000	Authorised	B2030
AE	139962	24/10/2016	26/09/2016	ITEM13	6000	6000	Authorised	B2030
					209000	206000
CamillaHemmingsen	139107	15/08/2016	22/06/2016	F039384	300000	91456	Authorised	G7009
CamillaHemmingsen	139845	10/10/2016	14/09/2016	F041154	100000	26452	Authorised	G7009
CamillaHemmingsen	139845	10/10/2016	14/09/2016	S428-65	100000	26452	Authorised	G7009
					500000	144360
CamillaHemmingsen	137199	27/01/2016	17/12/2015	F039529	400	0	Authorised	OD001
					400	0
Carole George	137473	01/02/2016	20/01/2016	F014073	2000	600	Authorised	R18010
Carole George	137473	01/02/2016	20/01/2016	S679J-60	2000	600	Authorised	R18010
					4000	1200
Carole George	134606	05/05/2015	14/04/2015	F039463	100000	100000	Authorised	W23023
Carole George	134800	02/06/2015	28/04/2015	F012916/1	300000	58700	Authorised	W23023
Carole George	136186	06/10/2015	17/09/2015	F039657	100000	8800	Authorised	W23023
Carole George	136188	06/10/2015	17/09/2015	F039656	100000	8800	Authorised	W23023
					600000	176300

[Anil_Babu_Samineni]

Try from Presentation Tab for the Field of Customer Code. Put Partial Sums for that

[#3]

sorry but I don't seem to have a sum option in the presentation tab

[krishnacbe]

Hi,

Hope you are using Straight table, in straight table you can have sub total. Convert the chart to Pivot and use the Partial sum to get the Sub Total.

[beck_bakytbek]

Hi Dave,

check this Topic: SUB Totals

i hope that helps

beck

[jonathandienst]

While it may be possible to somehow get subtotals into a straight table, it will be more complicated and probably perform poorly than simply using a pivot table.

[#7]

don't have the option to load data in only have the front end

[Anil_Babu_Samineni]

Like This

[#9]

that would be perfect I think

[jonathandienst]

Like I said, use a pivot table...