Subtotals not working

Anonymous — Fri, 01 Jun 2018 08:25:49 GMT

Hi,

I have the following expression in a straight table. If I use Expression total or sum of the rows I get the wrong subtotals in the gross sales collumn. the dimension description is a category of product we sell.

Sum(Gross_Sales*Multiplier)*COUNT(DISTINCT TBI_UNIQUE)/SUM(Multiplier)

DESCRIPTION	Net Sales	Gross Sales	Kgs	Cases	Total Cost	Tea Cost	Pack Cost	Lab/OH Cost	Actual Cost	New Kgs	Old Kgs
	539621	533607	345521	181361	392796	132862	167182	45085	389365	26749	27089.52
Decaf	4180	4180	191	1908	3726	1285	1424	0	3270	191	190.80
Earl Grey Base	1713	1713	185	693	1262	880	224	158	1312	185	184.80
Rare Teas	16432	16432	0	472	12568	12311	89	168	12440	208	208.00
Earl Grey	29706	29706	2144	8867	20549	8506	8269	3534	22029	2144	2144.00
Fruit & Herb	75428	75428	1604	21664	53068	11256	31568	9748	56441	1604	1603.59
Tea Flavoured	101073	101073	19150	31188	71493	19735	32035	10468	72197	5147	5147.49
Speciality	311088	305074	322248	116569	230129	78888	93573	21008	221677	17270	17610.83

If I change the dimensions to include the actual product line as well I get the correct total in gross sales but I want to show just the summarised data. Can anyone help me?

DESCRIPTION	TBI_PART_ONLY	Net Sales	Gross Sales	Kgs	Cases	Total Cost	Tea Cost	Pack Cost	Lab/OH Cost	Actual Cost	New Kgs	Old Kgs
		539621	531789	345521	181361	392796	132862	167182	45085	389365	26878	27089.52
Speciality	410-41-743	188	94	0	0	0	0	0	0	0	0	0.00
Rare Teas	410-40-734	42	42	0	2	35	340	1	37	1	1.00
Rare Teas	410-40-781	20	20	0	2	15	14	0	1	15	1	1.00
Rare Teas	410-40-782	30	30	0	2	18	16	0	2	18	1	1.00
Rare Teas	410-40-7058	323	323	0	2	224	222	0	2	170	1	1.00
Rare Teas	410-40-796	310	310	0	3	149	147	0	1	149	2	1.50
Rare Teas	410-40-707	93	93	0	4	172	170	0	2	178	2	2.00
Rare Teas	410-40-742	89	89	0	4	81	80	0	1	55	2	2.00
Rare Teas	410-40-743	89	89	0	4	81	80	0	1	77	2	2.00
Rare Teas	410-40-7004	856	856	0	4	701	700	0	1	701	2	2.00
Rare Teas	410-40-705	458	458	0	6	449	449	0	0	316	3	3.00
Rare Teas	410-40-713	398	398	0	6	281	280	0	1	241	3	3.00
Rare Teas	410-40-721	169	169	0	6	140	137	0	3	140	3	3.00
Rare Teas	410-40-738	133	133	0	6	159	157	0	3	132	3	3.00
Rare Teas	410-40-756	273	273	0	6	288	286	0	3	267	3	3.00
Rare Teas	410-40-7038	133	133	0	6	189	186	0	3	123	3	3.00
Rare Teas	410-40-7039	242	242	0	6	227	224	0	3	227	3	3.00
Rare Teas	410-40-7045	21	21	0	6	21	17	0	4	21	3	3.00
Rare Teas	410-40-7060	141	141	0	6	102	102	0	0	102	3	3.00
Rare Teas	410-40-7064	574	574	0	6	389	384	0	6	284	3	3.00
Rare Teas	410-40-7068	238	238	0	6	167	167	0	0	167	3	3.00
Rare Teas	410-40-786	295	295	0	8	317	315	0	2	346	4	4.00
Rare Teas	410-40-740	223	223	0	10	202	200	0	2	192	5	5.00
Rare Teas	410-40-741	223	223	0	10	191	189	0	2	202	5	5.00
Rare Teas	410-40-7002	896	896	0	10	699	697	0	2	726	5	5.00
Rare Teas	410-40-708	278	278	0	12	268	268	0	0	269	6	6.00
Rare Teas	410-40-735	431	431	0	12	342	336	0	6	379	6	6.00
Rare Teas	410-40-7042	314	314	0	12	308	305	0	3	210	6	6.00
Rare Teas	410-40-7069	443	443	0	12	309	309	0	0	309	6	6.00
Rare Teas	410-40-746	492	492	0	18	350	342	0	8	403	9	9.00
Rare Teas	410-40-755	88	88	0	18	127	119	0	8	127	9	9.00
Rare Teas	410-40-787	366	366	0	18	218	214	0	4	274	9	9.00
Rare Teas	410-40-7046	733	733	0	18	550	538	0	12	550	9	9.00
Rare Teas	410-40-749	1398	1398	0	24	566	555	0	10	600	12	12.00
Rare Teas	410-40-7072	1563	1563	0	24	1158	1140	0	18	1158	12	12.00
Rare Teas	410-40-7070	167	167	0	30	113	101	0	11	113	15	15.00
Rare Teas	410-40-7071	1593	1593	0	30	1177	1155	0	22	1177	15	15.00
Rare Teas	410-40-704	1990	1990	0	48	1532	1522	0	10	1726	24	24.00
Speciality	410-40-456	26	26	3	8	16	11	1	3	13	3	3.00
Tea Flavoured	410-40-415	54	54	6	16	32	23	2	7	34	6	6.00
Speciality	410-40-407	49	49	6	16	31	23	2	6	31	6	6.00
Speciality	410-40-463	44	44	6	16	37	29	2	7	37	6	6.00
Fruit & Herb	410-40-412	84	84	9	24	34	21	3	10	40	9	9.00
Tea Flavoured	410-40-411	84	84	9	24	39	26	3	10	43	9	9.00
Tea Flavoured	410-40-417	82	82	9	24	47	33	3	10	53	9	9.00
Speciality	410-41-193	73	73	6	24	37	28	3	6	37	6	6.00
Speciality	410-40-408	152	152	9	27	85	72	3	10	85	9	9.00
Speciality	410-40-406	149	149	12	32	69	52	4	13	68	12	12.00
Tea Flavoured	410-40-420	109	109	12	32	71	53	4	14	79	12	12.00
Speciality	410-45-016	30	30	10	12	49	35	4	9	48	10	9.60
Speciality	410-40-436	220	220	18	48	95	69	6	20	99	18	18.00
Speciality	410-40-448	137	137	14	56	66	44	7	15	73	14	14.00
Speciality	410-40-452	192	192	21	56	129	102	7	20	129	21	21.00
Speciality	410-40-434	232	232	21	49	316	286	7	23	315	21	21.00
Tea Flavoured	410-40-409	182	182	21	56	81	50	7	24	86	21	21.00
Speciality	410-40-419	190	190	21	56	128	96	7	24	157	21	21.00
Tea Flavoured	410-40-414	217	217	24	64	147	111	8	28	167	24	24.00
Speciality	410-40-433	454	454	27	72	136	98	9	30	136	27	27.00
Speciality	410-40-454	277	277	27	72	184	150	9	26	166	27	27.00
Tea Flavoured	410-40-443	289	289	27	72	133	98	9	27	155	27	27.00
Fruit & Herb	410-41-562	30	30	1	16	21	5	9	7	24	1	0.72
Speciality	410-45-105	247	247	15	90	108	84	10	14	108	15	15.00
Tea Flavoured	410-40-442	289	289	33	88	192	145	11	36	180	33	33.00
Earl Grey	410-40-437	1396	1396	162	432	796	630	12	154	954	162	162.00
Tea Flavoured	410-40-413	373	373	39	104	145	89	13	43	162	39	39.00
Speciality	410-40-429	331	331	45	120	271	213	15	43	276	45	45.00
Speciality	410-40-410	495	495	48	128	252	186	16	51	252	48	48.00
Speciality	410-40-424	535	535	51	136	334	268	17	49	361	51	51.00
Speciality	410-40-428	401	401	51	136	304	238	17	49	318	51	51.00
Speciality	410-40-425	522	522	54	144	327	257	18	52	323	54	54.00
Speciality	410-40-431	1302	1302	54	144	633	564	18	52	648	54	54.00
Speciality	410-41-873/1	109	109	7	6	74	21	18	0	86	7	7.20
Speciality	410-40-430	430	430	57	152	307	233	19	55	301	57	57.00
Speciality	410-40-440	1468	1468	57	152	1426	1347	19	60	1423	57	57.00
Earl Grey	410-45-103	257	257	18	150	115	75	22	19	131	18	18.00
Speciality	410-41-304	41	41	1144	12	35	4	23	1	34	1	1.20
Speciality	410-40-423	558	558	75	200	367	270	24	72	356	75	75.00
Speciality	410-40-427	532	532	81	216	340	235	26	78	340	81	81.00
Tea Flavoured	410-40-441	995	995	90	240	530	414	29	87	501	90	90.00
Speciality	410-41-525/1	90	90	5	48	76	21	29	0	67	5	4.80
Earl Grey	410-40-438	744	744	89	237	489	374	30	85	560	89	89.00
Speciality	410-40-439	602	602	62	248	452	356	30	66	450	62	62.00
Fruit & Herb	410-41-564	83	83	2	48	71	14	30	27	67	2	2.16
Speciality	410-41-527/1	112	112	6	60	91	27	32	0	85	6	6.00
Speciality	410-40-422	758	758	102	272	519	388	33	98	504	102	102.00
Speciality	410-41-309	266	266	15	55	118	60	38	20	167	15	15.00
Speciality	410-41-526	110	110	6	130	73	16	40	17	64	6	6.00
Tea Flavoured	410-40-444	1214	1214	90	360	723	588	44	92	244	90	90.00
Speciality	410-40-421	1048	1048	141	376	719	537	46	136	741	141	141.00
Speciality	410-41-874/1	212	212	14	12	164	45	48	0	153	14	14.40
Speciality	410-41-875/1	218	218	14	12	161	42	49	0	146	14	14.40
Speciality	410-41-150	189	189	12	80	121	46	52	24	131	12	12.00
Speciality	410-41-151	294	294	12	80	175	96	55	24	175	12	12.00
Speciality	410-41-111	163	163	12	72	142	58	62	22	138	12	12.00
Tea Flavoured	410-41-852/1	476	476	29	24	380	166	73	0	419	29	28.80
Speciality	410-41-834	251	251	8	18	155	36	83	36	212	8	7.50
Tea Flavoured	410-41-833	252	252	8	18	148	29	83	36	154	8	7.50
Rare Teas	410-41-318	303	303	0	65	255	154	89	12	262	5	4.50
Speciality	410-41-317	131	131	151	80	120	12	92	16	79	6	6.00
Speciality	410-41-315	283	283	295	160	176	52	94	30	183	12	12.00
Tea Flavoured	410-41-851/1	474	474	29	24	307	67	98	0	292	29	28.80
Speciality	410-41-135	333	333	15	90	187	58	101	27	198	15	15.00
Speciality	410-41-153	450	450	23	150	246	98	104	44	254	23	22.50
Speciality	410-41-114	349	349	24	128	230	83	107	40	251	24	24.00
Speciality	410-41-112	389	389	23	120	274	125	109	41	260	23	22.50
Tea Flavoured	410-41-853/1	478	478	29	24	356	97	117	0	318	29	28.80
Speciality	410-41-139	485	485	18	120	227	65	128	34	237	18	18.00
Tea Flavoured	410-41-543/1	618	618	30	300	362	66	136	0	485	30	30.00
Speciality	410-41-510/1	556	556	30	300	415	94	161	0	387	30	30.00
Tea Flavoured	410-41-544/1	640	640	30	300	389	66	163	0	515	30	30.00
Decaf	410-41-513/1	709	709	31	312	522	189	167	0	588	31	31.20
Speciality	410-41-854/1	476	476	29	24	415	105	168	0	357	29	28.80
Tea Flavoured	410-41-171	623	623	38	250	408	167	169	72	470	38	37.50
Tea Flavoured	410-41-172	627	627	38	250	384	140	169	75	436	38	37.50
Speciality	410-45-107	2134	2134	146	1220	870	543	172	155	875	146	146.40
Speciality	410-41-316	483	483	531	288	314	73	186	54	333	22	21.60
Tea Flavoured	410-41-156	735	735	44	290	406	126	188	92	456	44	43.50
Speciality	410-41-103	708	708	42	224	480	201	204	76	480	42	42.00
Speciality	410-41-405	1502	1502	180	675	1064	689	218	157	1091	180	180.00
Fruit & Herb	410-41-522/1	692	692	36	360	571	159	220	0	505	36	36.00
Earl Grey Base	410-41-406	1713	1713	185	693	1262	880	224	158	1312	185	184.80
Tea Flavoured	410-41-170	870	870	53	350	542	206	235	101	627	53	52.50
Speciality	410-41-468	533	533	627	100	573	59	241	44	227	15	15.00
Tea Flavoured	410-41-830	634	634	23	54	437	88	242	107	456	23	22.50
Tea Flavoured	410-41-550/1	913	913	44	444	582	104	242	0	563	44	44.40
Speciality	410-41-474	1453	1453	149	144	914	635	253	27	1234	10	9.72
Speciality	410-41-523/1	870	870	48	480	606	90	261	0	566	48	48.00
Speciality	410-41-596	692	692	11	250	502	118	274	111	448	11	11.25
Speciality	410-41-598	653	653	11	250	444	59	274	111	458	11	11.25
Speciality	410-41-542/1	1050	1050	51	510	689	140	277	0	625	51	51.00
Tea Flavoured	410-41-551/1	1288	1288	62	624	977	359	286	0	1060	62	62.40
Tea Flavoured	410-41-831	635	635	23	54	495	100	287	107	469	23	22.50
Speciality	410-41-478	1132	1132	165	160	519	200	290	29	806	11	10.80
Tea Flavoured	410-41-578	599	599	9	200	508	66	300	142	447	9	9.00
Fruit & Herb	410-41-158	1142	1142	68	450	610	160	307	143	782	68	67.50
Speciality	410-41-524	877	877	37	806	550	133	310	106	435	37	37.20
Tea Flavoured	410-41-157	1249	1249	73	486	637	168	315	154	747	73	72.87
Tea Flavoured	410-41-189	612	612	9	250	523	34	317	172	560	9	9.00
Tea Flavoured	410-41-832	845	845	30	72	604	139	322	143	719	30	30.00
Tea Flavoured	410-41-152	1210	1210	75	500	652	179	324	148	746	75	75.00
Tea Flavoured	410-41-552/1	1117	1117	54	540	801	183	330	0	730	54	54.00
Speciality	410-41-104	943	943	68	450	657	197	339	122	567	68	67.50
Tea Flavoured	410-41-174	1239	1239	75	500	836	348	339	149	958	75	75.00
Speciality	410-41-524/1	1093	1093	45	450	757	169	348	0	605	45	45.00
Fruit & Herb	410-41-545/1	1187	1187	57	570	838	185	349	0	799	57	57.00
Tea Flavoured	410-41-855/1	1383	1383	86	72	1030	253	351	0	963	86	86.40
Earl Grey	410-41-540/1	974	974	45	450	679	84	354	0	560	45	45.00
Tea Flavoured	410-41-109	1336	1336	74	392	832	339	356	137	825	74	73.50
Speciality	410-41-407	2497	2497	299	1123	1767	1143	362	261	1661	299	299.40
Earl Grey	410-41-107	1181	1181	75	450	802	293	370	139	849	75	75.00
Tea Flavoured	410-41-106	1213	1213	77	408	858	335	371	152	879	77	76.50
Speciality	410-41-136	1120	1120	57	342	816	328	380	108	865	57	57.00
Speciality	410-41-330	1766	1766	20293	795	590	62	387	140	797	16	15.90
Speciality	410-41-155	1529	1529	90	600	850	283	391	176	898	90	90.00
Tea Flavoured	410-41-503/1	1651	1651	85	852	1105	254	396	0	1138	85	85.20
Tea Flavoured	410-41-554/1	1345	1345	65	654	940	191	400	0	886	65	65.40
Speciality	410-41-521/1	1511	1511	75	750	1107	299	407	0	1046	75	75.00
Speciality	410-41-138	1202	1202	57	380	1306	780	417	108	1301	57	57.00
Tea Flavoured	410-41-010	1767	1767	150	400	1362	664	480	218	1310	150	150.00
Speciality	410-41-744	1147	574	4494	528	869	258	481	130	936	5	9.60
Speciality	410-41-467	1013	1013	1254	200	1144	115	481	88	453	30	30.00
Speciality	410-41-600/1	1293	1293	75	875	1133	238	503	0	1020	75	75.00
Speciality	410-41-173	1865	1865	113	750	1248	519	505	224	1494	113	112.50
Tea Flavoured	410-41-595	1241	1241	23	500	843	100	522	221	863	23	22.50
Speciality	410-41-553/1	1382	1382	67	672	1133	246	529	0	992	67	67.20
Speciality	410-41-328	2472	2472	28716	1125	834	86	549	198	1024	23	22.50
Speciality	410-41-154	2003	2003	113	750	1208	438	550	220	1232	113	112.50
Speciality	410-41-597	1869	1869	23	520	1335	553	552	230	1352	23	23.40
Speciality	410-41-306	1005	1005	28595	300	855	95	579	23	817	30	30.00
Tea Flavoured	410-41-159	2303	2303	126	840	1277	460	587	229	1436	126	126.00
Speciality	410-41-160	1595	1595	93	558	1262	454	628	180	1150	93	93.00
Speciality	410-41-004	2209	2209	225	600	1584	656	629	299	1689	225	225.00
Earl Grey	410-41-805	1665	1665	60	144	1156	235	644	277	1250	60	60.00
Speciality	410-41-013	2770	2770	204	544	1742	792	652	298	1758	204	204.00
Speciality	410-41-005	2468	2468	225	600	2010	1056	654	299	2097	225	225.00
Speciality	410-41-520/1	2044	2044	111	1110	1619	354	672	0	1433	111	111.00
Speciality	410-41-312	2440	2440	150	900	1690	722	689	280	1771	150	150.00
Earl Grey	410-41-108	2028	2028	131	783	1487	552	694	241	1551	131	130.50
Tea Flavoured	410-41-509/1	2622	2622	128	1284	1609	226	697	0	1501	128	128.40
Fruit & Herb	410-41-626	1501	1501	23	450	1077	137	705	234	1089	23	22.50
Fruit & Herb	410-41-624	1501	1501	23	450	1147	164	708	275	1167	23	22.50
Fruit & Herb	410-41-618	1531	1531	23	459	1207	232	737	239	1221	23	22.95
Speciality	410-41-011	2471	2471	255	680	2348	1238	771	339	2242	255	255.00
Tea Flavoured	410-41-594	1864	1864	34	750	1275	148	796	332	1331	34	33.75
Speciality	410-41-592	1820	1820	34	750	1258	129	797	332	1266	34	33.75
Fruit & Herb	410-41-185	2425	2425	90	612	1618	628	802	188	2006	90	89.76
Speciality	410-41-803	2125	2125	79	189	1528	370	812	347	1529	79	78.75
Speciality	410-41-541/1	2116	2116	105	1050	1783	396	827	0	1281	105	105.00
Speciality	410-41-134	1940	1940	114	684	1614	543	865	206	1641	114	114.00
Tea Flavoured	410-41-572	1731	1731	27	590	1467	163	886	418	1506	27	26.55
Speciality	410-41-859/1	5349	5349	353	294	4232	1604	889	0	4188	353	352.80
Speciality	410-41-807	2290	2290	86	207	1602	330	892	380	1615	86	86.25
Tea Flavoured	410-41-573	1790	1790	27	610	1514	166	916	432	1539	27	27.45
Tea Flavoured	410-41-574	1769	1769	27	610	1507	159	916	432	1445	27	27.45
Speciality	410-41-951	3112	1037	20443	972	1785	516	940	328	2040	41	121.50
Speciality	410-41-511/1	3334	3334	176	1758	2404	509	957	0	2256	176	175.80
Speciality	410-41-860/1	4129	4129	295	246	3530	1100	974	0	3297	295	295.20
Tea Flavoured	410-41-577	2028	2028	30	660	1739	281	991	467	1602	30	29.70
Speciality	410-41-329	4635	4635	53986	2115	1566	162	1030	373	1977	42	42.30
Speciality	410-41-591	2435	2435	45	1000	1675	172	1060	442	1682	45	45.00
Earl Grey	410-41-593	2489	2489	45	1000	1678	176	1060	442	1776	45	45.00
Speciality	410-41-003	4715	4715	375	1000	3383	1794	1090	499	3384	375	375.00
Speciality	410-41-505/1	4076	4076	93	1854	2511	388	1134	0	2351	93	92.70
Speciality	410-41-012	4627	4627	357	952	3593	1977	1141	475	3364	357	357.00
Tea Flavoured	410-41-869/1	5382	5382	338	282	3408	597	1143	0	3325	338	338.40
Speciality	410-41-131	3146	3146	153	918	2245	809	1161	276	2350	153	153.00
Earl Grey	410-41-008	4278	4278	375	1000	3283	1585	1193	505	3431	375	375.00
Speciality	410-41-620	2552	2552	38	765	1988	314	1198	476	2050	38	38.25
Speciality	410-41-856/1	4067	4067	295	246	3590	936	1199	0	2827	295	295.20
Speciality	410-41-952	2252	751	7990	855	1574	174	1205	195	1484	18	54.00
Earl Grey	410-41-314	4428	4428	263	1575	2743	1052	1206	486	2892	263	262.50
Tea Flavoured	410-41-601/1	3378	3378	180	2100	2517	368	1208	0	2339	180	180.00
Speciality	410-41-105	3595	3595	240	1600	2783	1126	1223	433	2760	240	240.00
Decaf	410-41-512/1	3471	3471	160	1596	3204	1096	1257	0	2682	160	159.60
Tea Flavoured	410-41-857/1	4703	4703	310	258	3417	633	1257	0	3136	310	309.60
Speciality	410-41-858/1	4404	4404	310	258	3886	1102	1257	0	3353	310	309.60
Speciality	410-41-137	5675	5675	170	1017	5623	4005	1286	332	5531	170	169.50
Speciality	410-41-501/1	5698	5698	288	2880	4164	1309	1318	0	4169	288	288.00
Speciality	410-41-132	3513	3513	206	1233	2604	845	1389	370	2421	206	205.50
Speciality	410-41-602/1	3714	3714	210	2450	3254	747	1409	0	2905	210	210.00
Tea Flavoured	410-41-579	2981	2981	36	1000	2534	354	1493	687	2434	36	36.00
Fruit & Herb	410-41-616	3302	3302	50	990	2253	231	1558	465	2253	50	49.50
Speciality	410-41-507/1	5754	5754	309	3088	4453	1151	1655	0	4201	309	308.80
Speciality	410-41-313	5875	5875	375	2250	3894	1472	1723	700	4139	375	375.00
Tea Flavoured	410-41-576	3479	3479	44	1220	2918	278	1802	839	2936	44	43.92
Tea Flavoured	410-41-504/1	5935	5935	300	3000	4049	614	1835	0	3727	300	300.00
Tea Flavoured	410-41-009	9324	9324	675	1800	6014	3117	1962	935	5914	675	675.00
Speciality	410-41-133	9505	9505	281	1683	5577	2943	2128	506	5365	281	280.50
Tea Flavoured	410-41-575	4856	4856	68	1520	3930	609	2245	1076	3953	68	68.40
Speciality	410-41-002	9652	9652	912	2432	7043	3483	2347	1213	7433	912	912.00
Speciality	410-41-950	5384	1795	136341	2250	3874	573	2367	933	4309	45	135.00
Tea Flavoured	410-41-006	9582	9582	819	2184	7180	3582	2381	1217	7829	819	819.00
Speciality	410-41-130	5761	5761	336	2016	4371	1216	2549	606	3770	336	336.00
Fruit & Herb	410-41-612	5374	5374	64	1611	3792	405	2585	801	3857	64	64.44
Speciality	410-41-102	7531	7531	518	3450	5547	1976	2638	933	5115	518	517.50
Earl Grey	410-41-007	10266	10266	882	2646	7320	3449	2684	1187	8074	882	882.00
Fruit & Herb	410-41-622	5944	5944	71	1782	4136	615	2778	743	4417	71	71.28
Fruit & Herb	410-41-610	6004	6004	72	1800	4500	693	2912	895	4601	72	72.00
Tea Flavoured	410-41-181	7392	7392	14260	2568	5293	1315	3178	801	6048	257	256.80
Speciality	410-41-606	8197	8197	68	2277	6425	1716	3629	1079	6327	68	68.31
Speciality	410-41-001	14161	14161	1338	4014	10984	5123	4081	1779	11263	1338	1338.00
Fruit & Herb	410-41-608	8976	8976	108	2691	6422	794	4290	1339	6732	108	107.64
Speciality	410-41-101	14059	14059	966	5152	9737	3699	4297	1741	10593	966	966.00
Fruit & Herb	410-41-212	19682	19682	669	4563	12649	5024	6219	1405	13267	669	669.24
Fruit & Herb	410-41-614	15971	15971	239	4788	12123	1788	7358	2977	13613	239	239.40
Speciality	410-41-502/1	23607	23607	1289	12888	18846	4087	7883	0	16891	1289	1288.80
Speciality	410-41-508/1	45351	45351	2425	24252	36405	8632	14834	0	32313	2425	2425.20

topic Subtotals not working in QlikView

Subtotals not working