sum of total receivable per year and per quarter

[#1]

Hi,

Can you help me how i can get the sum of per Quarter and per Year of my Receivable and how can i display it properly on the chart.

I don't know why the total sum of receivable per Year is the same in the total sum of receivable per Quarter. Help me guys and sorry for the long post

Year	Name	Receivable	Quarter
2009	ALASAS	1613488.7	1
2009	ALASAS	1613488.7	2
2009	ALASAS	1613488.7	3
2009	ALASAS	1613488.7	4
2009	BALITI	6568081.04	1
2009	BALITI	6568081.04	2
2009	BALITI	6568081.04	3
2009	BALITI	6568081.04	4
2009	BULAON	2033106.82	1
2009	BULAON	2033106.82	2
2009	BULAON	2033106.82	3
2009	BULAON	2033106.82	4
2009	CALULUT	4265549.02	1
2009	CALULUT	4265549.02	2
2009	CALULUT	4265549.02	3
2009	CALULUT	4265549.02	4
2009	DEL CARMEN	6188425.28	1
2009	DEL CARMEN	6188425.28	2
2009	DEL CARMEN	6188425.28	3
2009	DEL CARMEN	6188425.28	4
2009	DEL PILAR	5100402.12	1
2009	DEL PILAR	5100402.12	2
2009	DEL PILAR	5100402.12	3
2009	DEL PILAR	5100402.12	4
2009	DEL ROSARIO	9397775.48	1
2009	DEL ROSARIO	9397775.48	2
2009	DEL ROSARIO	9397775.48	3
2009	DEL ROSARIO	9397775.48	4
2009	DELA PAZ DUR	2022300.2	1
2009	DELA PAZ DUR	2022300.2	2
2009	DELA PAZ DUR	2022300.2	3
2009	DELA PAZ DUR	2022300.2	4
2009	DELA PAZ NORTE	4289713.68	1
2009	DELA PAZ NORTE	4289713.68	2
2009	DELA PAZ NORTE	4289713.68	3
2009	DELA PAZ NORTE	4289713.68	4
2009	DOLORES	30135092.4	1
2009	DOLORES	30135092.4	2
2009	DOLORES	30135092.4	3
2009	DOLORES	30135092.4	4
2009	JULIANA	1766343.92	1
2009	JULIANA	1766343.92	2
2009	JULIANA	1766343.92	3
2009	JULIANA	1766343.92	4
2009	LARA	1997332.44	1
2009	LARA	1997332.44	2
2009	LARA	1997332.44	3
2009	LARA	1997332.44	4
2009	LOURDES	1988563.62	1
2009	LOURDES	1988563.62	2
2009	LOURDES	1988563.62	3
2009	LOURDES	1988563.62	4
2009	MAGLIMAN	3976300.58	1
2009	MAGLIMAN	3976300.58	2
2009	MAGLIMAN	3976300.58	3
2009	MAGLIMAN	3976300.58	4
2009	MAIMPIS	15015116.7	1
2009	MAIMPIS	15015116.7	2
2009	MAIMPIS	15015116.7	3
2009	MAIMPIS	15015116.7	4
2009	MALINO	1404933.44	1
2009	MALINO	1404933.44	2
2009	MALINO	1404933.44	3
2009	MALINO	1404933.44	4
2009	MALPITIC	1367139.48	1
2009	MALPITIC	1367139.48	2
2009	MALPITIC	1367139.48	3
2009	MALPITIC	1367139.48	4
2009	PANDARAS	92458.26	1
2009	PANDARAS	92458.26	2
2009	PANDARAS	92458.26	3
2009	PANDARAS	92458.26	4
2009	PANIPUAN	4606346.86	1
2009	PANIPUAN	4606346.86	2
2009	PANIPUAN	4606346.86	3
2009	PANIPUAN	4606346.86	4
2009	POBLACION	14153801.1	1
2009	POBLACION	14153801.1	2
2009	POBLACION	14153801.1	3
2009	POBLACION	14153801.1	4
2009	PULUNG BULU	4065627.33	1
2009	PULUNG BULU	4065627.33	2
2009	PULUNG BULU	4065627.33	3
2009	PULUNG BULU	4065627.33	4
2009	QUEBIAWAN	27015699.9	1
2009	QUEBIAWAN	27015699.9	2
2009	QUEBIAWAN	27015699.9	3
2009	QUEBIAWAN	27015699.9	4
2009	SAGUIN	9642363	1
2009	SAGUIN	9642363	2
2009	SAGUIN	9642363	3
2009	SAGUIN	9642363	4
2009	SAN AGUSTIN	30584203.6	1
2009	SAN AGUSTIN	30584203.6	2
2009	SAN AGUSTIN	30584203.6	3
2009	SAN AGUSTIN	30584203.6	4
2009	SAN FELIPE	3533020.88	1
2009	SAN FELIPE	3533020.88	2
2009	SAN FELIPE	3533020.88	3
2009	SAN FELIPE	3533020.88	4
2009	SAN ISIDRO	6295223.72	1
2009	SAN ISIDRO	6295223.72	2
2009	SAN ISIDRO	6295223.72	3
2009	SAN ISIDRO	6295223.72	4
2009	SAN JOSE	28818077.6	1
2009	SAN JOSE	28818077.6	2
2009	SAN JOSE	28818077.6	3
2009	SAN JOSE	28818077.6	4
2009	SAN JUAN	3367561.12	1
2009	SAN JUAN	3367561.12	2
2009	SAN JUAN	3367561.12	3
2009	SAN JUAN	3367561.12	4
2009	SAN NICOLAS	2289425.69	1
2009	SAN NICOLAS	2289425.69	2
2009	SAN NICOLAS	2289425.69	3
2009	SAN NICOLAS	2289425.69	4
2009	SAN PEDRO	547995.86	1
2009	SAN PEDRO	547995.86	2
2009	SAN PEDRO	547995.86	3
2009	SAN PEDRO	547995.86	4
2009	SINDALAN	15768295	1
2009	SINDALAN	15768295	2
2009	SINDALAN	15768295	3
2009	SINDALAN	15768295	4
2009	STA TERESITA	461335.6	1
2009	STA TERESITA	461335.6	2
2009	STA TERESITA	461335.6	3
2009	STA TERESITA	461335.6	4
2009	STA. LUCIA	2039032.95	1
2009	STA. LUCIA	2039032.95	2
2009	STA. LUCIA	2039032.95	3
2009	STA. LUCIA	2039032.95	4
2009	STO. NIÑO	5716091.19	1
2009	STO. NIÑO	5716091.19	2
2009	STO. NIÑO	5716091.19	3
2009	STO. NIÑO	5716091.19	4
2009	TELABASTAGAN	16449083.4	1
2009	TELABASTAGAN	16449083.4	2
2009	TELABASTAGAN	16449083.4	3
2009	TELABASTAGAN	16449083.4	4
2010	ALASAS	1613488.7	1
2010	ALASAS	1613488.7	2
2010	ALASAS	1613488.7	3
2010	ALASAS	1613488.7	4
2010	BALITI	6568081.04	1
2010	BALITI	6568081.04	2
2010	BALITI	6568081.04	3
2010	BALITI	6568081.04	4
2010	BULAON	2033106.82	1
2010	BULAON	2033106.82	2
2010	BULAON	2033106.82	3
2010	BULAON	2033106.82	4
2010	CALULUT	4265549.02	1
2010	CALULUT	4265549.02	2
2010	CALULUT	4265549.02	3
2010	CALULUT	4265549.02	4
2010	DEL CARMEN	6188425.28	1
2010	DEL CARMEN	6188425.28	2
2010	DEL CARMEN	6188425.28	3
2010	DEL CARMEN	6188425.28	4
2010	DEL PILAR	5100402.12	1
2010	DEL PILAR	5100402.12	2
2010	DEL PILAR	5100402.12	3
2010	DEL PILAR	5100402.12	4
2010	DEL ROSARIO	9397775.48	1
2010	DEL ROSARIO	9397775.48	2
2010	DEL ROSARIO	9397775.48	3
2010	DEL ROSARIO	9397775.48	4
2010	DELA PAZ DUR	2022300.2	1
2010	DELA PAZ DUR	2022300.2	2
2010	DELA PAZ DUR	2022300.2	3
2010	DELA PAZ DUR	2022300.2	4
2010	DELA PAZ NORTE	4289713.68	1
2010	DELA PAZ NORTE	4289713.68	2
2010	DELA PAZ NORTE	4289713.68	3
2010	DELA PAZ NORTE	4289713.68	4
2010	DOLORES	30135092.4	1
2010	DOLORES	30135092.4	2
2010	DOLORES	30135092.4	3
2010	DOLORES	30135092.4	4
2010	JULIANA	1766343.92	1
2010	JULIANA	1766343.92	2
2010	JULIANA	1766343.92	3
2010	JULIANA	1766343.92	4
2010	LARA	1997332.44	1
2010	LARA	1997332.44	2
2010	LARA	1997332.44	3
2010	LARA	1997332.44	4
2010	LOURDES	1988563.62	1
2010	LOURDES	1988563.62	2
2010	LOURDES	1988563.62	3
2010	LOURDES	1988563.62	4
2010	MAGLIMAN	3976300.58	1
2010	MAGLIMAN	3976300.58	2
2010	MAGLIMAN	3976300.58	3
2010	MAGLIMAN	3976300.58	4
2010	MAIMPIS	15015116.7	1
2010	MAIMPIS	15015116.7	2
2010	MAIMPIS	15015116.7	3
2010	MAIMPIS	15015116.7	4
2010	MALINO	1404933.44	1
2010	MALINO	1404933.44	2
2010	MALINO	1404933.44	3
2010	MALINO	1404933.44	4
2010	MALPITIC	1367139.48	1
2010	MALPITIC	1367139.48	2
2010	MALPITIC	1367139.48	3
2010	MALPITIC	1367139.48	4
2010	PANDARAS	92458.26	1
2010	PANDARAS	92458.26	2
2010	PANDARAS	92458.26	3
2010	PANDARAS	92458.26	4
2010	PANIPUAN	4606346.86	1
2010	PANIPUAN	4606346.86	2
2010	PANIPUAN	4606346.86	3
2010	PANIPUAN	4606346.86	4
2010	POBLACION	14153801.1	1
2010	POBLACION	14153801.1	2
2010	POBLACION	14153801.1	3
2010	POBLACION	14153801.1	4
2010	PULUNG BULU	4065627.33	1
2010	PULUNG BULU	4065627.33	2
2010	PULUNG BULU	4065627.33	3
2010	PULUNG BULU	4065627.33	4
2010	QUEBIAWAN	27015699.9	1
2010	QUEBIAWAN	27015699.9	2
2010	QUEBIAWAN	27015699.9	3
2010	QUEBIAWAN	27015699.9	4
2010	SAGUIN	9642363	1
2010	SAGUIN	9642363	2
2010	SAGUIN	9642363	3
2010	SAGUIN	9642363	4
2010	SAN AGUSTIN	30584203.6	1
2010	SAN AGUSTIN	30584203.6	2
2010	SAN AGUSTIN	30584203.6	3
2010	SAN AGUSTIN	30584203.6	4
2010	SAN FELIPE	3533020.88	1
2010	SAN FELIPE	3533020.88	2
2010	SAN FELIPE	3533020.88	3
2010	SAN FELIPE	3533020.88	4
2010	SAN ISIDRO	6295223.72	1
2010	SAN ISIDRO	6295223.72	2
2010	SAN ISIDRO	6295223.72	3
2010	SAN ISIDRO	6295223.72	4
2010	SAN JOSE	28818077.6	1
2010	SAN JOSE	28818077.6	2
2010	SAN JOSE	28818077.6	3
2010	SAN JOSE	28818077.6	4
2010	SAN JUAN	3367561.12	1
2010	SAN JUAN	3367561.12	2
2010	SAN JUAN	3367561.12	3
2010	SAN JUAN	3367561.12	4
2010	SAN NICOLAS	2289425.69	1
2010	SAN NICOLAS	2289425.69	2
2010	SAN NICOLAS	2289425.69	3
2010	SAN NICOLAS	2289425.69	4
2010	SAN PEDRO	547995.86	1
2010	SAN PEDRO	547995.86	2
2010	SAN PEDRO	547995.86	3
2010	SAN PEDRO	547995.86	4
2010	SINDALAN	15768295	1
2010	SINDALAN	15768295	2
2010	SINDALAN	15768295	3
2010	SINDALAN	15768295	4
2010	STA TERESITA	461335.6	1
2010	STA TERESITA	461335.6	2
2010	STA TERESITA	461335.6	3
2010	STA TERESITA	461335.6	4
2010	STA. LUCIA	2039032.95	1
2010	STA. LUCIA	2039032.95	2
2010	STA. LUCIA	2039032.95	3
2010	STA. LUCIA	2039032.95	4
2010	STO. NIÑO	5716091.19	1
2010	STO. NIÑO	5716091.19	2
2010	STO. NIÑO	5716091.19	3
2010	STO. NIÑO	5716091.19	4
2010	TELABASTAGAN	16449083.4	1
2010	TELABASTAGAN	16449083.4	2
2010	TELABASTAGAN	16449083.4	3
2010	TELABASTAGAN	16449083.4	4
2011	ALASAS	1613488.7	1
2011	ALASAS	1613488.7	2
2011	ALASAS	1613488.7	3
2011	ALASAS	1613488.7	4
2011	BALITI	6568081.04	1
2011	BALITI	6568081.04	2
2011	BALITI	6568081.04	3
2011	BALITI	6568081.04	4
2011	BULAON	2033106.82	1
2011	BULAON	2033106.82	2
2011	BULAON	2033106.82	3
2011	BULAON	2033106.82	4
2011	CALULUT	4265549.02	1
2011	CALULUT	4265549.02	2
2011	CALULUT	4265549.02	3
2011	CALULUT	4265549.02	4
2011	DEL CARMEN	6188425.28	1
2011	DEL CARMEN	6188425.28	2
2011	DEL CARMEN	6188425.28	3
2011	DEL CARMEN	6188425.28	4
2011	DEL PILAR	5100402.12	1
2011	DEL PILAR	5100402.12	2
2011	DEL PILAR	5100402.12	3
2011	DEL PILAR	5100402.12	4
2011	DEL ROSARIO	9397775.48	1
2011	DEL ROSARIO	9397775.48	2
2011	DEL ROSARIO	9397775.48	3
2011	DEL ROSARIO	9397775.48	4
2011	DELA PAZ DUR	2022300.2	1
2011	DELA PAZ DUR	2022300.2	2
2011	DELA PAZ DUR	2022300.2	3
2011	DELA PAZ DUR	2022300.2	4
2011	DELA PAZ NORTE	4289713.68	1
2011	DELA PAZ NORTE	4289713.68	2
2011	DELA PAZ NORTE	4289713.68	3
2011	DELA PAZ NORTE	4289713.68	4
2011	DOLORES	30135092.4	1
2011	DOLORES	30135092.4	2
2011	DOLORES	30135092.4	3
2011	DOLORES	30135092.4	4
2011	JULIANA	1766343.92	1
2011	JULIANA	1766343.92	2
2011	JULIANA	1766343.92	3
2011	JULIANA	1766343.92	4
2011	LARA	1997332.44	1
2011	LARA	1997332.44	2
2011	LARA	1997332.44	3
2011	LARA	1997332.44	4
2011	LOURDES	1988563.62	1
2011	LOURDES	1988563.62	2
2011	LOURDES	1988563.62	3
2011	LOURDES	1988563.62	4
2011	MAGLIMAN	3976300.58	1
2011	MAGLIMAN	3976300.58	2
2011	MAGLIMAN	3976300.58	3
2011	MAGLIMAN	3976300.58	4
2011	MAIMPIS	15015116.7	1
2011	MAIMPIS	15015116.7	2
2011	MAIMPIS	15015116.7	3
2011	MAIMPIS	15015116.7	4
2011	MALINO	1404933.44	1
2011	MALINO	1404933.44	2
2011	MALINO	1404933.44	3
2011	MALINO	1404933.44	4
2011	MALPITIC	1367139.48	1
2011	MALPITIC	1367139.48	2
2011	MALPITIC	1367139.48	3
2011	MALPITIC	1367139.48	4
2011	PANDARAS	92458.26	1
2011	PANDARAS	92458.26	2
2011	PANDARAS	92458.26	3
2011	PANDARAS	92458.26	4
2011	PANIPUAN	4606346.86	1
2011	PANIPUAN	4606346.86	2
2011	PANIPUAN	4606346.86	3
2011	PANIPUAN	4606346.86	4
2011	POBLACION	14153801.1	1
2011	POBLACION	14153801.1	2
2011	POBLACION	14153801.1	3
2011	POBLACION	14153801.1	4
2011	PULUNG BULU	4065627.33	1
2011	PULUNG BULU	4065627.33	2
2011	PULUNG BULU	4065627.33	3
2011	PULUNG BULU	4065627.33	4
2011	QUEBIAWAN	27015699.9	1
2011	QUEBIAWAN	27015699.9	2
2011	QUEBIAWAN	27015699.9	3
2011	QUEBIAWAN	27015699.9	4
2011	SAGUIN	9642363	1
2011	SAGUIN	9642363	2
2011	SAGUIN	9642363	3
2011	SAGUIN	9642363	4
2011	SAN AGUSTIN	30584203.6	1
2011	SAN AGUSTIN	30584203.6	2
2011	SAN AGUSTIN	30584203.6	3
2011	SAN AGUSTIN	30584203.6	4
2011	SAN FELIPE	3533020.88	1
2011	SAN FELIPE	3533020.88	2
2011	SAN FELIPE	3533020.88	3
2011	SAN FELIPE	3533020.88	4
2011	SAN ISIDRO	6295223.72	1
2011	SAN ISIDRO	6295223.72	2
2011	SAN ISIDRO	6295223.72	3
2011	SAN ISIDRO	6295223.72	4
2011	SAN JOSE	28818077.6	1
2011	SAN JOSE	28818077.6	2
2011	SAN JOSE	28818077.6	3
2011	SAN JOSE	28818077.6	4
2011	SAN JUAN	3367561.12	1
2011	SAN JUAN	3367561.12	2
2011	SAN JUAN	3367561.12	3
2011	SAN JUAN	3367561.12	4
2011	SAN NICOLAS	2289425.69	1
2011	SAN NICOLAS	2289425.69	2
2011	SAN NICOLAS	2289425.69	3
2011	SAN NICOLAS	2289425.69	4
2011	SAN PEDRO	547995.86	1
2011	SAN PEDRO	547995.86	2
2011	SAN PEDRO	547995.86	3
2011	SAN PEDRO	547995.86	4
2011	SINDALAN	15768295	1
2011	SINDALAN	15768295	2
2011	SINDALAN	15768295	3
2011	SINDALAN	15768295	4
2011	STA TERESITA	461335.6	1
2011	STA TERESITA	461335.6	2
2011	STA TERESITA	461335.6	3
2011	STA TERESITA	461335.6	4
2011	STA. LUCIA	2039032.95	1
2011	STA. LUCIA	2039032.95	2
2011	STA. LUCIA	2039032.95	3
2011	STA. LUCIA	2039032.95	4
2011	STO. NIÑO	5716091.19	1
2011	STO. NIÑO	5716091.19	2
2011	STO. NIÑO	5716091.19	3
2011	STO. NIÑO	5716091.19	4
2011	TELABASTAGAN	16449083.4	1
2011	TELABASTAGAN	16449083.4	2
2011	TELABASTAGAN	16449083.4	3
2011	TELABASTAGAN	16449083.4	4
2012	ALASAS	1613488.7	1
2012	ALASAS	1613488.7	2
2012	ALASAS	1613488.7	3
2012	ALASAS	1613488.7	4
2012	BALITI	6568081.04	1
2012	BALITI	6568081.04	2
2012	BALITI	6568081.04	3
2012	BALITI	6568081.04	4
2012	BULAON	2033106.82	1
2012	BULAON	2033106.82	2
2012	BULAON	2033106.82	3
2012	BULAON	2033106.82	4
2012	CALULUT	4265549.02	1
2012	CALULUT	4265549.02	2
2012	CALULUT	4265549.02	3
2012	CALULUT	4265549.02	4
2012	DEL CARMEN	6188425.28	1
2012	DEL CARMEN	6188425.28	2
2012	DEL CARMEN	6188425.28	3
2012	DEL CARMEN	6188425.28	4
2012	DEL PILAR	5100402.12	1
2012	DEL PILAR	5100402.12	2
2012	DEL PILAR	5100402.12	3
2012	DEL PILAR	5100402.12	4
2012	DEL ROSARIO	9397775.48	1
2012	DEL ROSARIO	9397775.48	2
2012	DEL ROSARIO	9397775.48	3
2012	DEL ROSARIO	9397775.48	4
2012	DELA PAZ DUR	2022300.2	1
2012	DELA PAZ DUR	2022300.2	2
2012	DELA PAZ DUR	2022300.2	3
2012	DELA PAZ DUR	2022300.2	4
2012	DELA PAZ NORTE	4289713.68	1
2012	DELA PAZ NORTE	4289713.68	2
2012	DELA PAZ NORTE	4289713.68	3
2012	DELA PAZ NORTE	4289713.68	4
2012	DOLORES	30135092.4	1
2012	DOLORES	30135092.4	2
2012	DOLORES	30135092.4	3
2012	DOLORES	30135092.4	4
2012	JULIANA	1766343.92	1
2012	JULIANA	1766343.92	2
2012	JULIANA	1766343.92	3
2012	JULIANA	1766343.92	4
2012	LARA	1997332.44	1
2012	LARA	1997332.44	2
2012	LARA	1997332.44	3
2012	LARA	1997332.44	4
2012	LOURDES	1988563.62	1
2012	LOURDES	1988563.62	2
2012	LOURDES	1988563.62	3
2012	LOURDES	1988563.62	4
2012	MAGLIMAN	3976300.58	1
2012	MAGLIMAN	3976300.58	2
2012	MAGLIMAN	3976300.58	3
2012	MAGLIMAN	3976300.58	4
2012	MAIMPIS	15015116.7	1
2012	MAIMPIS	15015116.7	2
2012	MAIMPIS	15015116.7	3
2012	MAIMPIS	15015116.7	4
2012	MALINO	1404933.44	1
2012	MALINO	1404933.44	2
2012	MALINO	1404933.44	3
2012	MALINO	1404933.44	4
2012	MALPITIC	1367139.48	1
2012	MALPITIC	1367139.48	2
2012	MALPITIC	1367139.48	3
2012	MALPITIC	1367139.48	4
2012	PANDARAS	92458.26	1
2012	PANDARAS	92458.26	2
2012	PANDARAS	92458.26	3
2012	PANDARAS	92458.26	4
2012	PANIPUAN	4606346.86	1
2012	PANIPUAN	4606346.86	2
2012	PANIPUAN	4606346.86	3
2012	PANIPUAN	4606346.86	4
2012	POBLACION	14153801.1	1
2012	POBLACION	14153801.1	2
2012	POBLACION	14153801.1	3
2012	POBLACION	14153801.1	4
2012	PULUNG BULU	4065627.33	1
2012	PULUNG BULU	4065627.33	2
2012	PULUNG BULU	4065627.33	3
2012	PULUNG BULU	4065627.33	4
2012	QUEBIAWAN	27015699.9	1
2012	QUEBIAWAN	27015699.9	2
2012	QUEBIAWAN	27015699.9	3
2012	QUEBIAWAN	27015699.9	4
2012	SAGUIN	9642363	1
2012	SAGUIN	9642363	2
2012	SAGUIN	9642363	3
2012	SAGUIN	9642363	4
2012	SAN AGUSTIN	30584203.6	1
2012	SAN AGUSTIN	30584203.6	2
2012	SAN AGUSTIN	30584203.6	3
2012	SAN AGUSTIN	30584203.6	4
2012	SAN FELIPE	3533020.88	1
2012	SAN FELIPE	3533020.88	2
2012	SAN FELIPE	3533020.88	3
2012	SAN FELIPE	3533020.88	4
2012	SAN ISIDRO	6295223.72	1
2012	SAN ISIDRO	6295223.72	2
2012	SAN ISIDRO	6295223.72	3
2012	SAN ISIDRO	6295223.72	4
2012	SAN JOSE	28818077.6	1
2012	SAN JOSE	28818077.6	2
2012	SAN JOSE	28818077.6	3
2012	SAN JOSE	28818077.6	4
2012	SAN JUAN	3367561.12	1
2012	SAN JUAN	3367561.12	2
2012	SAN JUAN	3367561.12	3
2012	SAN JUAN	3367561.12	4
2012	SAN NICOLAS	2289425.69	1
2012	SAN NICOLAS	2289425.69	2
2012	SAN NICOLAS	2289425.69	3
2012	SAN NICOLAS	2289425.69	4
2012	SAN PEDRO	547995.86	1
2012	SAN PEDRO	547995.86	2
2012	SAN PEDRO	547995.86	3
2012	SAN PEDRO	547995.86	4
2012	SINDALAN	15768295	1
2012	SINDALAN	15768295	2
2012	SINDALAN	15768295	3
2012	SINDALAN	15768295	4
2012	STA TERESITA	461335.6	1
2012	STA TERESITA	461335.6	2
2012	STA TERESITA	461335.6	3
2012	STA TERESITA	461335.6	4
2012	STA. LUCIA	2039032.95	1
2012	STA. LUCIA	2039032.95	2
2012	STA. LUCIA	2039032.95	3
2012	STA. LUCIA	2039032.95	4
2012	STO. NIÑO	5716091.19	1
2012	STO. NIÑO	5716091.19	2
2012	STO. NIÑO	5716091.19	3
2012	STO. NIÑO	5716091.19	4
2012	TELABASTAGAN	16449083.4	1
2012	TELABASTAGAN	16449083.4	2
2012	TELABASTAGAN	16449083.4	3
2012	TELABASTAGAN	16449083.4	4
2013	ALASAS	1613488.7	1
2013	ALASAS	1613488.7	2
2013	ALASAS	1613488.7	3
2013	ALASAS	1613488.7	4
2013	BALITI	6568081.04	1
2013	BALITI	6568081.04	2
2013	BALITI	6568081.04	3
2013	BALITI	6568081.04	4
2013	BULAON	2033106.82	1
2013	BULAON	2033106.82	2
2013	BULAON	2033106.82	3
2013	BULAON	2033106.82	4
2013	CALULUT	4265549.02	1
2013	CALULUT	4265549.02	2
2013	CALULUT	4265549.02	3
2013	CALULUT	4265549.02	4
2013	DEL CARMEN	6188425.28	1
2013	DEL CARMEN	6188425.28	2
2013	DEL CARMEN	6188425.28	3
2013	DEL CARMEN	6188425.28	4
2013	DEL PILAR	5100402.12	1
2013	DEL PILAR	5100402.12	2
2013	DEL PILAR	5100402.12	3
2013	DEL PILAR	5100402.12	4
2013	DEL ROSARIO	9397775.48	1
2013	DEL ROSARIO	9397775.48	2
2013	DEL ROSARIO	9397775.48	3
2013	DEL ROSARIO	9397775.48	4
2013	DELA PAZ DUR	2022300.2	1
2013	DELA PAZ DUR	2022300.2	2
2013	DELA PAZ DUR	2022300.2	3
2013	DELA PAZ DUR	2022300.2	4
2013	DELA PAZ NORTE	4289713.68	1
2013	DELA PAZ NORTE	4289713.68	2
2013	DELA PAZ NORTE	4289713.68	3
2013	DELA PAZ NORTE	4289713.68	4
2013	DOLORES	30135092.4	1
2013	DOLORES	30135092.4	2
2013	DOLORES	30135092.4	3
2013	DOLORES	30135092.4	4
2013	JULIANA	1766343.92	1
2013	JULIANA	1766343.92	2
2013	JULIANA	1766343.92	3
2013	JULIANA	1766343.92	4
2013	LARA	1997332.44	1
2013	LARA	1997332.44	2
2013	LARA	1997332.44	3
2013	LARA	1997332.44	4
2013	LOURDES	1988563.62	1
2013	LOURDES	1988563.62	2
2013	LOURDES	1988563.62	3
2013	LOURDES	1988563.62	4
2013	MAGLIMAN	3976300.58	1
2013	MAGLIMAN	3976300.58	2
2013	MAGLIMAN	3976300.58	3
2013	MAGLIMAN	3976300.58	4
2013	MAIMPIS	15015116.7	1
2013	MAIMPIS	15015116.7	2
2013	MAIMPIS	15015116.7	3
2013	MAIMPIS	15015116.7	4
2013	MALINO	1404933.44	1
2013	MALINO	1404933.44	2
2013	MALINO	1404933.44	3
2013	MALINO	1404933.44	4
2013	MALPITIC	1367139.48	1
2013	MALPITIC	1367139.48	2
2013	MALPITIC	1367139.48	3
2013	MALPITIC	1367139.48	4
2013	PANDARAS	92458.26	1
2013	PANDARAS	92458.26	2
2013	PANDARAS	92458.26	3
2013	PANDARAS	92458.26	4
2013	PANIPUAN	4606346.86	1
2013	PANIPUAN	4606346.86	2
2013	PANIPUAN	4606346.86	3
2013	PANIPUAN	4606346.86	4
2013	POBLACION	14153801.1	1
2013	POBLACION	14153801.1	2
2013	POBLACION	14153801.1	3
2013	POBLACION	14153801.1	4
2013	PULUNG BULU	4065627.33	1
2013	PULUNG BULU	4065627.33	2
2013	PULUNG BULU	4065627.33	3
2013	PULUNG BULU	4065627.33	4
2013	QUEBIAWAN	27015699.9	1
2013	QUEBIAWAN	27015699.9	2
2013	QUEBIAWAN	27015699.9	3
2013	QUEBIAWAN	27015699.9	4
2013	SAGUIN	9642363	1
2013	SAGUIN	9642363	2
2013	SAGUIN	9642363	3
2013	SAGUIN	9642363	4
2013	SAN AGUSTIN	30584203.6	1
2013	SAN AGUSTIN	30584203.6	2
2013	SAN AGUSTIN	30584203.6	3
2013	SAN AGUSTIN	30584203.6	4
2013	SAN FELIPE	3533020.88	1
2013	SAN FELIPE	3533020.88	2
2013	SAN FELIPE	3533020.88	3
2013	SAN FELIPE	3533020.88	4
2013	SAN ISIDRO	6295223.72	1
2013	SAN ISIDRO	6295223.72	2
2013	SAN ISIDRO	6295223.72	3
2013	SAN ISIDRO	6295223.72	4
2013	SAN JOSE	28818077.6	1
2013	SAN JOSE	28818077.6	2
2013	SAN JOSE	28818077.6	3
2013	SAN JOSE	28818077.6	4
2013	SAN JUAN	3367561.12	1
2013	SAN JUAN	3367561.12	2
2013	SAN JUAN	3367561.12	3
2013	SAN JUAN	3367561.12	4
2013	SAN NICOLAS	2289425.69	1
2013	SAN NICOLAS	2289425.69	2
2013	SAN NICOLAS	2289425.69	3
2013	SAN NICOLAS	2289425.69	4
2013	SAN PEDRO	547995.86	1
2013	SAN PEDRO	547995.86	2
2013	SAN PEDRO	547995.86	3
2013	SAN PEDRO	547995.86	4
2013	SINDALAN	15768295	1
2013	SINDALAN	15768295	2
2013	SINDALAN	15768295	3
2013	SINDALAN	15768295	4
2013	STA TERESITA	461335.6	1
2013	STA TERESITA	461335.6	2
2013	STA TERESITA	461335.6	3
2013	STA TERESITA	461335.6	4
2013	STA. LUCIA	2039032.95	1
2013	STA. LUCIA	2039032.95	2
2013	STA. LUCIA	2039032.95	3
2013	STA. LUCIA	2039032.95	4
2013	STO. NIÑO	5716091.19	1
2013	STO. NIÑO	5716091.19	2
2013	STO. NIÑO	5716091.19	3
2013	STO. NIÑO	5716091.19	4
2013	TELABASTAGAN	16449083.4	1
2013	TELABASTAGAN	16449083.4	2
2013	TELABASTAGAN	16449083.4	3
2013	TELABASTAGAN	16449083.4	4
2014	ALASAS	1613488.7	1
2014	ALASAS	1613488.7	2
2014	ALASAS	1613488.7	3
2014	ALASAS	1613488.7	4
2014	BALITI	6568081.04	1
2014	BALITI	6568081.04	2
2014	BALITI	6568081.04	3
2014	BALITI	6568081.04	4
2014	BULAON	2033106.82	1
2014	BULAON	2033106.82	2
2014	BULAON	2033106.82	3
2014	BULAON	2033106.82	4
2014	CALULUT	4265549.02	1
2014	CALULUT	4265549.02	2
2014	CALULUT	4265549.02	3
2014	CALULUT	4265549.02	4
2014	DEL CARMEN	6188425.28	1
2014	DEL CARMEN	6188425.28	2
2014	DEL CARMEN	6188425.28	3
2014	DEL CARMEN	6188425.28	4
2014	DEL PILAR	5100402.12	1
2014	DEL PILAR	5100402.12	2
2014	DEL PILAR	5100402.12	3
2014	DEL PILAR	5100402.12	4
2014	DEL ROSARIO	9397775.48	1
2014	DEL ROSARIO	9397775.48	2
2014	DEL ROSARIO	9397775.48	3
2014	DEL ROSARIO	9397775.48	4
2014	DELA PAZ DUR	2022300.2	1
2014	DELA PAZ DUR	2022300.2	2
2014	DELA PAZ DUR	2022300.2	3
2014	DELA PAZ DUR	2022300.2	4
2014	DELA PAZ NORTE	4289713.68	1
2014	DELA PAZ NORTE	4289713.68	2
2014	DELA PAZ NORTE	4289713.68	3
2014	DELA PAZ NORTE	4289713.68	4
2014	DOLORES	30135092.4	1
2014	DOLORES	30135092.4	2
2014	DOLORES	30135092.4	3
2014	DOLORES	30135092.4	4
2014	JULIANA	1766343.92	1
2014	JULIANA	1766343.92	2
2014	JULIANA	1766343.92	3
2014	JULIANA	1766343.92	4
2014	LARA	1997332.44	1
2014	LARA	1997332.44	2
2014	LARA	1997332.44	3
2014	LARA	1997332.44	4
2014	LOURDES	1988563.62	1
2014	LOURDES	1988563.62	2
2014	LOURDES	1988563.62	3
2014	LOURDES	1988563.62	4
2014	MAGLIMAN	3976300.58	1
2014	MAGLIMAN	3976300.58	2
2014	MAGLIMAN	3976300.58	3
2014	MAGLIMAN	3976300.58	4
2014	MAIMPIS	15015116.7	1
2014	MAIMPIS	15015116.7	2
2014	MAIMPIS	15015116.7	3
2014	MAIMPIS	15015116.7	4
2014	MALINO	1404933.44	1
2014	MALINO	1404933.44	2
2014	MALINO	1404933.44	3
2014	MALINO	1404933.44	4
2014	MALPITIC	1367139.48	1
2014	MALPITIC	1367139.48	2
2014	MALPITIC	1367139.48	3
2014	MALPITIC	1367139.48	4
2014	PANDARAS	92458.26	1
2014	PANDARAS	92458.26	2
2014	PANDARAS	92458.26	3
2014	PANDARAS	92458.26	4
2014	PANIPUAN	4606346.86	1
2014	PANIPUAN	4606346.86	2
2014	PANIPUAN	4606346.86	3
2014	PANIPUAN	4606346.86	4
2014	POBLACION	14153801.1	1
2014	POBLACION	14153801.1	2
2014	POBLACION	14153801.1	3
2014	POBLACION	14153801.1	4
2014	PULUNG BULU	4065627.33	1
2014	PULUNG BULU	4065627.33	2
2014	PULUNG BULU	4065627.33	3
2014	PULUNG BULU	4065627.33	4
2014	QUEBIAWAN	27015699.9	1
2014	QUEBIAWAN	27015699.9	2
2014	QUEBIAWAN	27015699.9	3
2014	QUEBIAWAN	27015699.9	4
2014	SAGUIN	9642363	1
2014	SAGUIN	9642363	2
2014	SAGUIN	9642363	3
2014	SAGUIN	9642363	4
2014	SAN AGUSTIN	30584203.6	1
2014	SAN AGUSTIN	30584203.6	2
2014	SAN AGUSTIN	30584203.6	3
2014	SAN AGUSTIN	30584203.6	4
2014	SAN FELIPE	3533020.88	1
2014	SAN FELIPE	3533020.88	2
2014	SAN FELIPE	3533020.88	3
2014	SAN FELIPE	3533020.88	4
2014	SAN ISIDRO	6295223.72	1
2014	SAN ISIDRO	6295223.72	2
2014	SAN ISIDRO	6295223.72	3
2014	SAN ISIDRO	6295223.72	4
2014	SAN JOSE	28818077.6	1
2014	SAN JOSE	28818077.6	2
2014	SAN JOSE	28818077.6	3
2014	SAN JOSE	28818077.6	4
2014	SAN JUAN	3367561.12	1
2014	SAN JUAN	3367561.12	2
2014	SAN JUAN	3367561.12	3
2014	SAN JUAN	3367561.12	4
2014	SAN NICOLAS	2289425.69	1
2014	SAN NICOLAS	2289425.69	2
2014	SAN NICOLAS	2289425.69	3
2014	SAN NICOLAS	2289425.69	4
2014	SAN PEDRO	547995.86	1
2014	SAN PEDRO	547995.86	2
2014	SAN PEDRO	547995.86	3
2014	SAN PEDRO	547995.86	4
2014	SINDALAN	15768295	1
2014	SINDALAN	15768295	2
2014	SINDALAN	15768295	3
2014	SINDALAN	15768295	4
2014	STA TERESITA	461335.6	1
2014	STA TERESITA	461335.6	2
2014	STA TERESITA	461335.6	3
2014	STA TERESITA	461335.6	4
2014	STA. LUCIA	2039032.95	1
2014	STA. LUCIA	2039032.95	2
2014	STA. LUCIA	2039032.95	3
2014	STA. LUCIA	2039032.95	4
2014	STO. NIÑO	5716091.19	1
2014	STO. NIÑO	5716091.19	2
2014	STO. NIÑO	5716091.19	3
2014	STO. NIÑO	5716091.19	4
2014	TELABASTAGAN	16449083.4	1
2014	TELABASTAGAN	16449083.4	2
2014	TELABASTAGAN	16449083.4	3
2014	TELABASTAGAN	16449083.4	4
2015	ALASAS	1613488.7	1
2015	ALASAS	1613488.7	2
2015	ALASAS	1613488.7	3
2015	ALASAS	1613488.7	4
2015	BALITI	6568081.04	1
2015	BALITI	6568081.04	2
2015	BALITI	6568081.04	3
2015	BALITI	6568081.04	4
2015	BULAON	2033106.82	1
2015	BULAON	2033106.82	2
2015	BULAON	2033106.82	3
2015	BULAON	2033106.82	4
2015	CALULUT	4265549.02	1
2015	CALULUT	4265549.02	2
2015	CALULUT	4265549.02	3
2015	CALULUT	4265549.02	4
2015	DEL CARMEN	6188425.28	1
2015	DEL CARMEN	6188425.28	2
2015	DEL CARMEN	6188425.28	3
2015	DEL CARMEN	6188425.28	4
2015	DEL PILAR	5100402.12	1
2015	DEL PILAR	5100402.12	2
2015	DEL PILAR	5100402.12	3
2015	DEL PILAR	5100402.12	4
2015	DEL ROSARIO	9397775.48	1
2015	DEL ROSARIO	9397775.48	2
2015	DEL ROSARIO	9397775.48	3
2015	DEL ROSARIO	9397775.48	4
2015	DELA PAZ DUR	2022300.2	1
2015	DELA PAZ DUR	2022300.2	2
2015	DELA PAZ DUR	2022300.2	3
2015	DELA PAZ DUR	2022300.2	4
2015	DELA PAZ NORTE	4289713.68	1
2015	DELA PAZ NORTE	4289713.68	2
2015	DELA PAZ NORTE	4289713.68	3
2015	DELA PAZ NORTE	4289713.68	4
2015	DOLORES	30135092.4	1
2015	DOLORES	30135092.4	2
2015	DOLORES	30135092.4	3
2015	DOLORES	30135092.4	4
2015	JULIANA	1766343.92	1
2015	JULIANA	1766343.92	2
2015	JULIANA	1766343.92	3
2015	JULIANA	1766343.92	4
2015	LARA	1997332.44	1
2015	LARA	1997332.44	2
2015	LARA	1997332.44	3
2015	LARA	1997332.44	4
2015	LOURDES	1988563.62	1
2015	LOURDES	1988563.62	2
2015	LOURDES	1988563.62	3
2015	LOURDES	1988563.62	4
2015	MAGLIMAN	3976300.58	1
2015	MAGLIMAN	3976300.58	2
2015	MAGLIMAN	3976300.58	3
2015	MAGLIMAN	3976300.58	4
2015	MAIMPIS	15015116.7	1
2015	MAIMPIS	15015116.7	2
2015	MAIMPIS	15015116.7	3
2015	MAIMPIS	15015116.7	4
2015	MALINO	1404933.44	1
2015	MALINO	1404933.44	2
2015	MALINO	1404933.44	3
2015	MALINO	1404933.44	4
2015	MALPITIC	1367139.48	1
2015	MALPITIC	1367139.48	2
2015	MALPITIC	1367139.48	3
2015	MALPITIC	1367139.48	4
2015	PANDARAS	92458.26	1
2015	PANDARAS	92458.26	2
2015	PANDARAS	92458.26	3
2015	PANDARAS	92458.26	4
2015	PANIPUAN	4606346.86	1
2015	PANIPUAN	4606346.86	2
2015	PANIPUAN	4606346.86	3
2015	PANIPUAN	4606346.86	4
2015	POBLACION	14153801.1	1
2015	POBLACION	14153801.1	2
2015	POBLACION	14153801.1	3
2015	POBLACION	14153801.1	4
2015	PULUNG BULU	4065627.33	1
2015	PULUNG BULU	4065627.33	2
2015	PULUNG BULU	4065627.33	3
2015	PULUNG BULU	4065627.33	4
2015	QUEBIAWAN	27015699.9	1
2015	QUEBIAWAN	27015699.9	2
2015	QUEBIAWAN	27015699.9	3
2015	QUEBIAWAN	27015699.9	4
2015	SAGUIN	9642363	1
2015	SAGUIN	9642363	2
2015	SAGUIN	9642363	3
2015	SAGUIN	9642363	4
2015	SAN AGUSTIN	30584203.6	1
2015	SAN AGUSTIN	30584203.6	2
2015	SAN AGUSTIN	30584203.6	3
2015	SAN AGUSTIN	30584203.6	4
2015	SAN FELIPE	3533020.88	1
2015	SAN FELIPE	3533020.88	2
2015	SAN FELIPE	3533020.88	3
2015	SAN FELIPE	3533020.88	4
2015	SAN ISIDRO	6295223.72	1
2015	SAN ISIDRO	6295223.72	2
2015	SAN ISIDRO	6295223.72	3
2015	SAN ISIDRO	6295223.72	4
2015	SAN JOSE	28818077.6	1
2015	SAN JOSE	28818077.6	2
2015	SAN JOSE	28818077.6	3
2015	SAN JOSE	28818077.6	4
2015	SAN JUAN	3367561.12	1
2015	SAN JUAN	3367561.12	2
2015	SAN JUAN	3367561.12	3
2015	SAN JUAN	3367561.12	4
2015	SAN NICOLAS	2289425.69	1
2015	SAN NICOLAS	2289425.69	2
2015	SAN NICOLAS	2289425.69	3
2015	SAN NICOLAS	2289425.69	4
2015	SAN PEDRO	547995.86	1
2015	SAN PEDRO	547995.86	2
2015	SAN PEDRO	547995.86	3
2015	SAN PEDRO	547995.86	4
2015	SINDALAN	15768295	1
2015	SINDALAN	15768295	2
2015	SINDALAN	15768295	3
2015	SINDALAN	15768295	4
2015	STA TERESITA	461335.6	1
2015	STA TERESITA	461335.6	2
2015	STA TERESITA	461335.6	3
2015	STA TERESITA	461335.6	4
2015	STA. LUCIA	2039032.95	1
2015	STA. LUCIA	2039032.95	2
2015	STA. LUCIA	2039032.95	3
2015	STA. LUCIA	2039032.95	4
2015	STO. NIÑO	5716091.19	1
2015	STO. NIÑO	5716091.19	2
2015	STO. NIÑO	5716091.19	3
2015	STO. NIÑO	5716091.19	4
2015	TELABASTAGAN	16449083.4	1
2015	TELABASTAGAN	16449083.4	2
2015	TELABASTAGAN	16449083.4	3
2015	TELABASTAGAN	16449083.4	4

[swuehl]

Could you upload a screenshot of your data model or even better your sample QVW?

How are your calendar fields Year and Quarter linked to field tot_recv?

If these fields are not linked properly, this would explain the same sum showing on every dimension value (because QV will not be able to group the tot_recv values by the dimension values, just showing the total sum.

[ramoncova06]

I am not seeing the same results