Getting the sum per year and per quater - Qlik Community

Report Inappropriate Content · ‎2015-06-16

Good day people of Qlik,

Can you help me how to display the Sum of Per Year and Per Quarter of my Receivables.

Sorry for the long post, please help me in my project. thank you in advance

Year	Quarter	Recievables

2009	1	1613488.7
2009	2	1613488.7
2009	3	1613488.7
2009	4	1613488.7
2009	1	6568081.04
2009	2	6568081.04
2009	3	6568081.04
2009	4	6568081.04
2009	1	2033106.82
2009	2	2033106.82
2009	3	2033106.82
2009	4	2033106.82
2009	1	4265549.02
2009	2	4265549.02
2009	3	4265549.02
2009	4	4265549.02
2009	1	6188425.28
2009	2	6188425.28
2009	3	6188425.28
2009	4	6188425.28
2009	1	5100402.12
2009	2	5100402.12
2009	3	5100402.12
2009	4	5100402.12
2009	1	9397775.48
2009	2	9397775.48
2009	3	9397775.48
2009	4	9397775.48
2009	1	2022300.2
2009	2	2022300.2
2009	3	2022300.2
2009	4	2022300.2
2009	1	4289713.68
2009	2	4289713.68
2009	3	4289713.68
2009	4	4289713.68
2009	1	30135092.36
2009	2	30135092.36
2009	3	30135092.36
2009	4	30135092.36
2009	1	1766343.92
2009	2	1766343.92
2009	3	1766343.92
2009	4	1766343.92
2009	1	1997332.44
2009	2	1997332.44
2009	3	1997332.44
2009	4	1997332.44
2009	1	1988563.62
2009	2	1988563.62
2009	3	1988563.62
2009	4	1988563.62
2009	1	3976300.58
2009	2	3976300.58
2009	3	3976300.58
2009	4	3976300.58
2009	1	15015116.7
2009	2	15015116.7
2009	3	15015116.7
2009	4	15015116.7
2009	1	1404933.44
2009	2	1404933.44
2009	3	1404933.44
2009	4	1404933.44
2009	1	1367139.48
2009	2	1367139.48
2009	3	1367139.48
2009	4	1367139.48
2009	1	92458.26
2009	2	92458.26
2009	3	92458.26
2009	4	92458.26
2009	1	4606346.86
2009	2	4606346.86
2009	3	4606346.86
2009	4	4606346.86
2009	1	14153801.06
2009	2	14153801.06
2009	3	14153801.06
2009	4	14153801.06
2009	1	4065627.33
2009	2	4065627.33
2009	3	4065627.33
2009	4	4065627.33
2009	1	27015699.9
2009	2	27015699.9
2009	3	27015699.9
2009	4	27015699.9
2009	1	9642363
2009	2	9642363
2009	3	9642363
2009	4	9642363
2009	1	30584203.6
2009	2	30584203.6
2009	3	30584203.6
2009	4	30584203.6
2009	1	3533020.88
2009	2	3533020.88
2009	3	3533020.88
2009	4	3533020.88
2009	1	6295223.72
2009	2	6295223.72
2009	3	6295223.72
2009	4	6295223.72
2009	1	28818077.62
2009	2	28818077.62
2009	3	28818077.62
2009	4	28818077.62
2009	1	3367561.12
2009	2	3367561.12
2009	3	3367561.12
2009	4	3367561.12
2009	1	2289425.69
2009	2	2289425.69
2009	3	2289425.69
2009	4	2289425.69
2009	1	547995.86
2009	2	547995.86
2009	3	547995.86
2009	4	547995.86
2009	1	15768294.98
2009	2	15768294.98
2009	3	15768294.98
2009	4	15768294.98
2009	1	461335.6
2009	2	461335.6
2009	3	461335.6
2009	4	461335.6
2009	1	2039032.95
2009	2	2039032.95
2009	3	2039032.95
2009	4	2039032.95
2009	1	5716091.19
2009	2	5716091.19
2009	3	5716091.19
2009	4	5716091.19
2009	1	16449083.41
2009	2	16449083.41
2009	3	16449083.41
2009	4	16449083.41
2010	1	1613488.7
2010	2	1613488.7
2010	3	1613488.7
2010	4	1613488.7
2010	1	6568081.04
2010	2	6568081.04
2010	3	6568081.04
2010	4	6568081.04
2010	1	2033106.82
2010	2	2033106.82
2010	3	2033106.82
2010	4	2033106.82
2010	1	4265549.02
2010	2	4265549.02
2010	3	4265549.02
2010	4	4265549.02
2010	1	6188425.28
2010	2	6188425.28
2010	3	6188425.28
2010	4	6188425.28
2010	1	5100402.12
2010	2	5100402.12
2010	3	5100402.12
2010	4	5100402.12
2010	1	9397775.48
2010	2	9397775.48
2010	3	9397775.48
2010	4	9397775.48
2010	1	2022300.2
2010	2	2022300.2
2010	3	2022300.2
2010	4	2022300.2
2010	1	4289713.68
2010	2	4289713.68
2010	3	4289713.68
2010	4	4289713.68
2010	1	30135092.36
2010	2	30135092.36
2010	3	30135092.36
2010	4	30135092.36
2010	1	1766343.92
2010	2	1766343.92
2010	3	1766343.92
2010	4	1766343.92
2010	1	1997332.44
2010	2	1997332.44
2010	3	1997332.44
2010	4	1997332.44
2010	1	1988563.62
2010	2	1988563.62
2010	3	1988563.62
2010	4	1988563.62
2010	1	3976300.58
2010	2	3976300.58
2010	3	3976300.58
2010	4	3976300.58
2010	1	15015116.7
2010	2	15015116.7
2010	3	15015116.7
2010	4	15015116.7
2010	1	1404933.44
2010	2	1404933.44
2010	3	1404933.44
2010	4	1404933.44
2010	1	1367139.48
2010	2	1367139.48
2010	3	1367139.48
2010	4	1367139.48
2010	1	92458.26
2010	2	92458.26
2010	3	92458.26
2010	4	92458.26
2010	1	4606346.86
2010	2	4606346.86
2010	3	4606346.86
2010	4	4606346.86
2010	1	14153801.06
2010	2	14153801.06
2010	3	14153801.06
2010	4	14153801.06
2010	1	4065627.33
2010	2	4065627.33
2010	3	4065627.33
2010	4	4065627.33
2010	1	27015699.9
2010	2	27015699.9
2010	3	27015699.9
2010	4	27015699.9
2010	1	9642363
2010	2	9642363
2010	3	9642363
2010	4	9642363
2010	1	30584203.6
2010	2	30584203.6
2010	3	30584203.6
2010	4	30584203.6
2010	1	3533020.88
2010	2	3533020.88
2010	3	3533020.88
2010	4	3533020.88
2010	1	6295223.72
2010	2	6295223.72
2010	3	6295223.72
2010	4	6295223.72
2010	1	28818077.62
2010	2	28818077.62
2010	3	28818077.62
2010	4	28818077.62
2010	1	3367561.12
2010	2	3367561.12
2010	3	3367561.12
2010	4	3367561.12
2010	1	2289425.69
2010	2	2289425.69
2010	3	2289425.69
2010	4	2289425.69
2010	1	547995.86
2010	2	547995.86
2010	3	547995.86
2010	4	547995.86
2010	1	15768294.98
2010	2	15768294.98
2010	3	15768294.98
2010	4	15768294.98
2010	1	461335.6
2010	2	461335.6
2010	3	461335.6
2010	4	461335.6
2010	1	2039032.95
2010	2	2039032.95
2010	3	2039032.95
2010	4	2039032.95
2010	1	5716091.19
2010	2	5716091.19
2010	3	5716091.19
2010	4	5716091.19
2010	1	16449083.41
2010	2	16449083.41
2010	3	16449083.41
2010	4	16449083.41
2011	1	1613488.7
2011	2	1613488.7
2011	3	1613488.7
2011	4	1613488.7
2011	1	6568081.04
2011	2	6568081.04
2011	3	6568081.04
2011	4	6568081.04
2011	1	2033106.82
2011	2	2033106.82
2011	3	2033106.82
2011	4	2033106.82
2011	1	4265549.02
2011	2	4265549.02
2011	3	4265549.02
2011	4	4265549.02
2011	1	6188425.28
2011	2	6188425.28
2011	3	6188425.28
2011	4	6188425.28
2011	1	5100402.12
2011	2	5100402.12
2011	3	5100402.12
2011	4	5100402.12
2011	1	9397775.48
2011	2	9397775.48
2011	3	9397775.48
2011	4	9397775.48
2011	1	2022300.2
2011	2	2022300.2
2011	3	2022300.2
2011	4	2022300.2
2011	1	4289713.68
2011	2	4289713.68
2011	3	4289713.68
2011	4	4289713.68
2011	1	30135092.36
2011	2	30135092.36
2011	3	30135092.36
2011	4	30135092.36
2011	1	1766343.92
2011	2	1766343.92
2011	3	1766343.92
2011	4	1766343.92
2011	1	1997332.44
2011	2	1997332.44
2011	3	1997332.44
2011	4	1997332.44
2011	1	1988563.62
2011	2	1988563.62
2011	3	1988563.62
2011	4	1988563.62
2011	1	3976300.58
2011	2	3976300.58
2011	3	3976300.58
2011	4	3976300.58
2011	1	15015116.7
2011	2	15015116.7
2011	3	15015116.7
2011	4	15015116.7
2011	1	1404933.44
2011	2	1404933.44
2011	3	1404933.44
2011	4	1404933.44
2011	1	1367139.48
2011	2	1367139.48
2011	3	1367139.48
2011	4	1367139.48
2011	1	92458.26
2011	2	92458.26
2011	3	92458.26
2011	4	92458.26
2011	1	4606346.86
2011	2	4606346.86
2011	3	4606346.86
2011	4	4606346.86
2011	1	14153801.06
2011	2	14153801.06
2011	3	14153801.06
2011	4	14153801.06
2011	1	4065627.33
2011	2	4065627.33
2011	3	4065627.33
2011	4	4065627.33
2011	1	27015699.9
2011	2	27015699.9
2011	3	27015699.9
2011	4	27015699.9
2011	1	9642363
2011	2	9642363
2011	3	9642363
2011	4	9642363
2011	1	30584203.6
2011	2	30584203.6
2011	3	30584203.6
2011	4	30584203.6
2011	1	3533020.88
2011	2	3533020.88
2011	3	3533020.88
2011	4	3533020.88
2011	1	6295223.72
2011	2	6295223.72
2011	3	6295223.72
2011	4	6295223.72
2011	1	28818077.62
2011	2	28818077.62
2011	3	28818077.62
2011	4	28818077.62
2011	1	3367561.12
2011	2	3367561.12
2011	3	3367561.12
2011	4	3367561.12
2011	1	2289425.69
2011	2	2289425.69
2011	3	2289425.69
2011	4	2289425.69
2011	1	547995.86
2011	2	547995.86
2011	3	547995.86
2011	4	547995.86
2011	1	15768294.98
2011	2	15768294.98
2011	3	15768294.98
2011	4	15768294.98
2011	1	461335.6
2011	2	461335.6
2011	3	461335.6
2011	4	461335.6
2011	1	2039032.95
2011	2	2039032.95
2011	3	2039032.95
2011	4	2039032.95
2011	1	5716091.19
2011	2	5716091.19
2011	3	5716091.19
2011	4	5716091.19
2011	1	16449083.41
2011	2	16449083.41
2011	3	16449083.41
2011	4	16449083.41
2012	1	1613488.7
2012	2	1613488.7
2012	3	1613488.7
2012	4	1613488.7
2012	1	6568081.04
2012	2	6568081.04
2012	3	6568081.04
2012	4	6568081.04
2012	1	2033106.82
2012	2	2033106.82
2012	3	2033106.82
2012	4	2033106.82
2012	1	4265549.02
2012	2	4265549.02
2012	3	4265549.02
2012	4	4265549.02
2012	1	6188425.28
2012	2	6188425.28
2012	3	6188425.28
2012	4	6188425.28
2012	1	5100402.12
2012	2	5100402.12
2012	3	5100402.12
2012	4	5100402.12
2012	1	9397775.48
2012	2	9397775.48
2012	3	9397775.48
2012	4	9397775.48
2012	1	2022300.2
2012	2	2022300.2
2012	3	2022300.2
2012	4	2022300.2
2012	1	4289713.68
2012	2	4289713.68
2012	3	4289713.68
2012	4	4289713.68
2012	1	30135092.36
2012	2	30135092.36
2012	3	30135092.36
2012	4	30135092.36
2012	1	1766343.92
2012	2	1766343.92
2012	3	1766343.92
2012	4	1766343.92
2012	1	1997332.44
2012	2	1997332.44
2012	3	1997332.44
2012	4	1997332.44
2012	1	1988563.62
2012	2	1988563.62
2012	3	1988563.62
2012	4	1988563.62
2012	1	3976300.58
2012	2	3976300.58
2012	3	3976300.58
2012	4	3976300.58
2012	1	15015116.7
2012	2	15015116.7
2012	3	15015116.7
2012	4	15015116.7
2012	1	1404933.44
2012	2	1404933.44
2012	3	1404933.44
2012	4	1404933.44
2012	1	1367139.48
2012	2	1367139.48
2012	3	1367139.48
2012	4	1367139.48
2012	1	92458.26
2012	2	92458.26
2012	3	92458.26
2012	4	92458.26
2012	1	4606346.86
2012	2	4606346.86
2012	3	4606346.86
2012	4	4606346.86
2012	1	14153801.06
2012	2	14153801.06
2012	3	14153801.06
2012	4	14153801.06
2012	1	4065627.33
2012	2	4065627.33
2012	3	4065627.33
2012	4	4065627.33
2012	1	27015699.9
2012	2	27015699.9
2012	3	27015699.9
2012	4	27015699.9
2012	1	9642363
2012	2	9642363
2012	3	9642363
2012	4	9642363
2012	1	30584203.6
2012	2	30584203.6
2012	3	30584203.6
2012	4	30584203.6
2012	1	3533020.88
2012	2	3533020.88
2012	3	3533020.88
2012	4	3533020.88
2012	1	6295223.72
2012	2	6295223.72
2012	3	6295223.72
2012	4	6295223.72
2012	1	28818077.62
2012	2	28818077.62
2012	3	28818077.62
2012	4	28818077.62
2012	1	3367561.12
2012	2	3367561.12
2012	3	3367561.12
2012	4	3367561.12
2012	1	2289425.69
2012	2	2289425.69
2012	3	2289425.69
2012	4	2289425.69
2012	1	547995.86
2012	2	547995.86
2012	3	547995.86
2012	4	547995.86
2012	1	15768294.98
2012	2	15768294.98
2012	3	15768294.98
2012	4	15768294.98
2012	1	461335.6
2012	2	461335.6
2012	3	461335.6
2012	4	461335.6
2012	1	2039032.95
2012	2	2039032.95
2012	3	2039032.95
2012	4	2039032.95
2012	1	5716091.19
2012	2	5716091.19
2012	3	5716091.19
2012	4	5716091.19
2012	1	16449083.41
2012	2	16449083.41
2012	3	16449083.41
2012	4	16449083.41
2013	4	1613488.7
2013	3	1613488.7
2013	2	1613488.7
2013	1	1613488.7
2013	4	6568081.04
2013	3	6568081.04
2013	2	6568081.04
2013	1	6568081.04
2013	4	2033106.82
2013	3	2033106.82
2013	2	2033106.82
2013	1	2033106.82
2013	4	4265549.02
2013	3	4265549.02
2013	2	4265549.02
2013	1	4265549.02
2013	4	6188425.28
2013	3	6188425.28
2013	2	6188425.28
2013	1	6188425.28
2013	4	5100402.12
2013	3	5100402.12
2013	2	5100402.12
2013	1	5100402.12
2013	4	9397775.48
2013	3	9397775.48
2013	2	9397775.48
2013	1	9397775.48
2013	4	2022300.2
2013	3	2022300.2
2013	2	2022300.2
2013	1	2022300.2
2013	4	4289713.68
2013	3	4289713.68
2013	2	4289713.68
2013	1	4289713.68
2013	4	30135092.36
2013	3	30135092.36
2013	2	30135092.36
2013	1	30135092.36
2013	4	1766343.92
2013	3	1766343.92
2013	2	1766343.92
2013	1	1766343.92
2013	4	1997332.44
2013	3	1997332.44
2013	2	1997332.44
2013	1	1997332.44
2013	4	1988563.62
2013	3	1988563.62
2013	2	1988563.62
2013	1	1988563.62
2013	4	3976300.58
2013	3	3976300.58
2013	2	3976300.58
2013	1	3976300.58
2013	4	15015116.7
2013	3	15015116.7
2013	2	15015116.7
2013	1	15015116.7
2013	4	1404933.44
2013	3	1404933.44
2013	2	1404933.44
2013	1	1404933.44
2013	4	1367139.48
2013	3	1367139.48
2013	2	1367139.48
2013	1	1367139.48
2013	4	92458.26
2013	3	92458.26
2013	2	92458.26
2013	1	92458.26
2013	4	4606346.86
2013	3	4606346.86
2013	2	4606346.86
2013	1	4606346.86
2013	4	14153801.06
2013	3	14153801.06
2013	2	14153801.06
2013	1	14153801.06
2013	4	4065627.33
2013	3	4065627.33
2013	2	4065627.33
2013	1	4065627.33
2013	4	27015699.9
2013	3	27015699.9
2013	2	27015699.9
2013	1	27015699.9
2013	4	9642363
2013	3	9642363
2013	2	9642363
2013	1	9642363
2013	4	30584203.6
2013	3	30584203.6
2013	2	30584203.6
2013	1	30584203.6
2013	4	3533020.88
2013	3	3533020.88
2013	2	3533020.88
2013	1	3533020.88
2013	4	6295223.72
2013	3	6295223.72
2013	2	6295223.72
2013	1	6295223.72
2013	4	28818077.62
2013	3	28818077.62
2013	2	28818077.62
2013	1	28818077.62
2013	4	3367561.12
2013	3	3367561.12
2013	2	3367561.12
2013	1	3367561.12
2013	4	2289425.69
2013	3	2289425.69
2013	2	2289425.69
2013	1	2289425.69
2013	4	547995.86
2013	3	547995.86
2013	2	547995.86
2013	1	547995.86
2013	4	15768294.98
2013	3	15768294.98
2013	2	15768294.98
2013	1	15768294.98
2013	4	461335.6
2013	3	461335.6
2013	2	461335.6
2013	1	461335.6
2013	4	2039032.95
2013	3	2039032.95
2013	2	2039032.95
2013	1	2039032.95
2013	4	5716091.19
2013	3	5716091.19
2013	2	5716091.19
2013	1	5716091.19
2013	4	16449083.41
2013	3	16449083.41
2013	2	16449083.41
2013	1	16449083.41
2014	4	1613488.7
2014	3	1613488.7
2014	2	1613488.7
2014	1	1613488.7
2014	4	6568081.04
2014	3	6568081.04
2014	2	6568081.04
2014	1	6568081.04
2014	4	2033106.82
2014	3	2033106.82
2014	2	2033106.82
2014	1	2033106.82
2014	4	4265549.02
2014	3	4265549.02
2014	2	4265549.02
2014	1	4265549.02
2014	4	6188425.28
2014	3	6188425.28
2014	2	6188425.28
2014	1	6188425.28
2014	4	5100402.12
2014	3	5100402.12
2014	2	5100402.12
2014	1	5100402.12
2014	4	9397775.48
2014	3	9397775.48
2014	2	9397775.48
2014	1	9397775.48
2014	4	2022300.2
2014	3	2022300.2
2014	2	2022300.2
2014	1	2022300.2
2014	4	4289713.68
2014	3	4289713.68
2014	2	4289713.68
2014	1	4289713.68
2014	4	30135092.36
2014	3	30135092.36
2014	2	30135092.36
2014	1	30135092.36
2014	4	1766343.92
2014	3	1766343.92
2014	2	1766343.92
2014	1	1766343.92
2014	4	1997332.44
2014	3	1997332.44
2014	2	1997332.44
2014	1	1997332.44
2014	4	1988563.62
2014	3	1988563.62
2014	2	1988563.62
2014	1	1988563.62
2014	4	3976300.58
2014	3	3976300.58
2014	2	3976300.58
2014	1	3976300.58
2014	4	15015116.7
2014	3	15015116.7
2014	2	15015116.7
2014	1	15015116.7
2014	4	1404933.44
2014	3	1404933.44
2014	2	1404933.44
2014	1	1404933.44
2014	4	1367139.48
2014	3	1367139.48
2014	2	1367139.48
2014	1	1367139.48
2014	4	92458.26
2014	3	92458.26
2014	2	92458.26
2014	1	92458.26
2014	4	4606346.86
2014	3	4606346.86
2014	2	4606346.86
2014	1	4606346.86
2014	4	14153801.06
2014	3	14153801.06
2014	2	14153801.06
2014	1	14153801.06
2014	4	4065627.33
2014	3	4065627.33
2014	2	4065627.33
2014	1	4065627.33
2014	4	27015699.9
2014	3	27015699.9
2014	2	27015699.9
2014	1	27015699.9
2014	4	9642363
2014	3	9642363
2014	2	9642363
2014	1	9642363
2014	4	30584203.6
2014	3	30584203.6
2014	2	30584203.6
2014	1	30584203.6
2014	4	3533020.88
2014	3	3533020.88
2014	2	3533020.88
2014	1	3533020.88
2014	4	6295223.72
2014	3	6295223.72
2014	2	6295223.72
2014	1	6295223.72
2014	4	28818077.62
2014	3	28818077.62
2014	2	28818077.62
2014	1	28818077.62
2014	4	3367561.12
2014	3	3367561.12
2014	2	3367561.12
2014	1	3367561.12
2014	4	2289425.69
2014	3	2289425.69
2014	2	2289425.69
2014	1	2289425.69
2014	4	547995.86
2014	3	547995.86
2014	2	547995.86
2014	1	547995.86
2014	4	15768294.98
2014	3	15768294.98
2014	2	15768294.98
2014	1	15768294.98
2014	4	461335.6
2014	3	461335.6
2014	2	461335.6
2014	1	461335.6
2014	4	2039032.95
2014	3	2039032.95
2014	2	2039032.95
2014	1	2039032.95
2014	4	5716091.19
2014	3	5716091.19
2014	2	5716091.19
2014	1	5716091.19
2014	4	16449083.41
2014	3	16449083.41
2014	2	16449083.41
2014	1	16449083.41
2015	4	1613488.7
2015	3	1613488.7
2015	1	1613488.7
2015	2	1613488.7
2015	4	6568081.04
2015	3	6568081.04
2015	1	6568081.04
2015	2	6568081.04
2015	4	2033106.82
2015	3	2033106.82
2015	1	2033106.82
2015	2	2033106.82
2015	4	4265549.02
2015	3	4265549.02
2015	1	4265549.02
2015	2	4265549.02
2015	4	6188425.28
2015	3	6188425.28
2015	1	6188425.28
2015	2	6188425.28
2015	4	5100402.12
2015	3	5100402.12
2015	1	5100402.12
2015	2	5100402.12
2015	4	9397775.48
2015	3	9397775.48
2015	1	9397775.48
2015	2	9397775.48
2015	4	2022300.2
2015	3	2022300.2
2015	1	2022300.2
2015	2	2022300.2
2015	4	4289713.68
2015	3	4289713.68
2015	1	4289713.68
2015	2	4289713.68
2015	4	30135092.36
2015	3	30135092.36
2015	1	30135092.36
2015	2	30135092.36
2015	4	1766343.92
2015	3	1766343.92
2015	1	1766343.92
2015	2	1766343.92
2015	4	1997332.44
2015	3	1997332.44
2015	1	1997332.44
2015	2	1997332.44
2015	4	1988563.62
2015	3	1988563.62
2015	1	1988563.62
2015	2	1988563.62
2015	4	3976300.58
2015	3	3976300.58
2015	1	3976300.58
2015	2	3976300.58
2015	4	15015116.7
2015	3	15015116.7
2015	1	15015116.7
2015	2	15015116.7
2015	4	1404933.44
2015	3	1404933.44
2015	1	1404933.44
2015	2	1404933.44
2015	4	1367139.48
2015	3	1367139.48
2015	1	1367139.48
2015	2	1367139.48
2015	4	92458.26
2015	3	92458.26
2015	1	92458.26
2015	2	92458.26
2015	4	4606346.86
2015	3	4606346.86
2015	1	4606346.86
2015	2	4606346.86
2015	4	14153801.06
2015	3	14153801.06
2015	1	14153801.06
2015	2	14153801.06
2015	4	4065627.33
2015	3	4065627.33
2015	1	4065627.33
2015	2	4065627.33
2015	4	27015699.9
2015	3	27015699.9
2015	1	27015699.9
2015	2	27015699.9
2015	4	9642363
2015	3	9642363
2015	1	9642363
2015	2	9642363
2015	4	30584203.6
2015	3	30584203.6
2015	1	30584203.6
2015	2	30584203.6
2015	4	3533020.88
2015	3	3533020.88
2015	1	3533020.88
2015	2	3533020.88
2015	4	6295223.72
2015	3	6295223.72
2015	1	6295223.72
2015	2	6295223.72
2015	4	28818077.62
2015	3	28818077.62
2015	1	28818077.62
2015	2	28818077.62
2015	4	3367561.12
2015	3	3367561.12
2015	1	3367561.12
2015	2	3367561.12
2015	4	2289425.69
2015	3	2289425.69
2015	1	2289425.69
2015	2	2289425.69
2015	4	547995.86
2015	3	547995.86
2015	1	547995.86
2015	2	547995.86
2015	4	15768294.98
2015	3	15768294.98
2015	1	15768294.98
2015	2	15768294.98
2015	4	461335.6
2015	3	461335.6
2015	1	461335.6
2015	2	461335.6
2015	4	2039032.95
2015	3	2039032.95
2015	1	2039032.95
2015	2	2039032.95
2015	4	5716091.19
2015	3	5716091.19
2015	1	5716091.19
2015	2	5716091.19
2015	4	16449083.41
2015	3	16449083.41
2015	1	16449083.41
2015	2	16449083.41

oknotsen · ‎2015-06-16

Make a Pivot table.

Be sure to turn on "Show Partial Sum" (found on the presentation tab) for Quarter; this will give you the total per year. The default expression result will be your sum per quarter.

May you live in interesting times!

Report Inappropriate Content · ‎2015-06-16

Sir on the Pivot table it only show the sum of 1 quarter for the whole year.

Agis-Kalogiannis · ‎2015-06-16

This s not a pivot table. this is a straight table.

You can do the following:

Create a Pivot Table

First Dim: Year

Second: Quarter

Expression: sum(Receivables)

Thanks

oknotsen · ‎2015-06-16

Without viewing the actual expressions, I can not see why they are not equal and can only assume that you are not using the same expressions and dimensions.

May you live in interesting times!

prashantbaste · ‎2015-06-16

Please find attached QVW & let me know if you are looking for the same solution.

--

Regards,

Prashant P Baste

awhitfield · ‎2015-06-16

HI Lester,

can you upload your qvw for investigation?

Andy