Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

sum of total receivable per year and per quarter

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

Untitled.png

   

YearNameReceivableQuarter
2009ALASAS1613488.71
2009ALASAS1613488.72
2009ALASAS1613488.73
2009ALASAS1613488.74
2009BALITI6568081.041
2009BALITI6568081.042
2009BALITI6568081.043
2009BALITI6568081.044
2009BULAON2033106.821
2009BULAON2033106.822
2009BULAON2033106.823
2009BULAON2033106.824
2009CALULUT4265549.021
2009CALULUT4265549.022
2009CALULUT4265549.023
2009CALULUT4265549.024
2009DEL CARMEN6188425.281
2009DEL CARMEN6188425.282
2009DEL CARMEN6188425.283
2009DEL CARMEN6188425.284
2009DEL PILAR5100402.121
2009DEL PILAR5100402.122
2009DEL PILAR5100402.123
2009DEL PILAR5100402.124
2009DEL ROSARIO9397775.481
2009DEL ROSARIO9397775.482
2009DEL ROSARIO9397775.483
2009DEL ROSARIO9397775.484
2009DELA PAZ DUR2022300.21
2009DELA PAZ DUR2022300.22
2009DELA PAZ DUR2022300.23
2009DELA PAZ DUR2022300.24
2009DELA PAZ NORTE4289713.681
2009DELA PAZ NORTE4289713.682
2009DELA PAZ NORTE4289713.683
2009DELA PAZ NORTE4289713.684
2009DOLORES30135092.41
2009DOLORES30135092.42
2009DOLORES30135092.43
2009DOLORES30135092.44
2009JULIANA1766343.921
2009JULIANA1766343.922
2009JULIANA1766343.923
2009JULIANA1766343.924
2009LARA1997332.441
2009LARA1997332.442
2009LARA1997332.443
2009LARA1997332.444
2009LOURDES1988563.621
2009LOURDES1988563.622
2009LOURDES1988563.623
2009LOURDES1988563.624
2009MAGLIMAN3976300.581
2009MAGLIMAN3976300.582
2009MAGLIMAN3976300.583
2009MAGLIMAN3976300.584
2009MAIMPIS15015116.71
2009MAIMPIS15015116.72
2009MAIMPIS15015116.73
2009MAIMPIS15015116.74
2009MALINO1404933.441
2009MALINO1404933.442
2009MALINO1404933.443
2009MALINO1404933.444
2009MALPITIC1367139.481
2009MALPITIC1367139.482
2009MALPITIC1367139.483
2009MALPITIC1367139.484
2009PANDARAS92458.261
2009PANDARAS92458.262
2009PANDARAS92458.263
2009PANDARAS92458.264
2009PANIPUAN4606346.861
2009PANIPUAN4606346.862
2009PANIPUAN4606346.863
2009PANIPUAN4606346.864
2009POBLACION14153801.11
2009POBLACION14153801.12
2009POBLACION14153801.13
2009POBLACION14153801.14
2009PULUNG BULU4065627.331
2009PULUNG BULU4065627.332
2009PULUNG BULU4065627.333
2009PULUNG BULU4065627.334
2009QUEBIAWAN27015699.91
2009QUEBIAWAN27015699.92
2009QUEBIAWAN27015699.93
2009QUEBIAWAN27015699.94
2009SAGUIN96423631
2009SAGUIN96423632
2009SAGUIN96423633
2009SAGUIN96423634
2009SAN AGUSTIN30584203.61
2009SAN AGUSTIN30584203.62
2009SAN AGUSTIN30584203.63
2009SAN AGUSTIN30584203.64
2009SAN FELIPE3533020.881
2009SAN FELIPE3533020.882
2009SAN FELIPE3533020.883
2009SAN FELIPE3533020.884
2009SAN ISIDRO6295223.721
2009SAN ISIDRO6295223.722
2009SAN ISIDRO6295223.723
2009SAN ISIDRO6295223.724
2009SAN JOSE28818077.61
2009SAN JOSE28818077.62
2009SAN JOSE28818077.63
2009SAN JOSE28818077.64
2009SAN JUAN3367561.121
2009SAN JUAN3367561.122
2009SAN JUAN3367561.123
2009SAN JUAN3367561.124
2009SAN NICOLAS2289425.691
2009SAN NICOLAS2289425.692
2009SAN NICOLAS2289425.693
2009SAN NICOLAS2289425.694
2009SAN PEDRO547995.861
2009SAN PEDRO547995.862
2009SAN PEDRO547995.863
2009SAN PEDRO547995.864
2009SINDALAN157682951
2009SINDALAN157682952
2009SINDALAN157682953
2009SINDALAN157682954
2009STA TERESITA461335.61
2009STA TERESITA461335.62
2009STA TERESITA461335.63
2009STA TERESITA461335.64
2009STA. LUCIA2039032.951
2009STA. LUCIA2039032.952
2009STA. LUCIA2039032.953
2009STA. LUCIA2039032.954
2009STO. NIÑO5716091.191
2009STO. NIÑO5716091.192
2009STO. NIÑO5716091.193
2009STO. NIÑO5716091.194
2009TELABASTAGAN16449083.41
2009TELABASTAGAN16449083.42
2009TELABASTAGAN16449083.43
2009TELABASTAGAN16449083.44
2010ALASAS1613488.71
2010ALASAS1613488.72
2010ALASAS1613488.73
2010ALASAS1613488.74
2010BALITI6568081.041
2010BALITI6568081.042
2010BALITI6568081.043
2010BALITI6568081.044
2010BULAON2033106.821
2010BULAON2033106.822
2010BULAON2033106.823
2010BULAON2033106.824
2010CALULUT4265549.021
2010CALULUT4265549.022
2010CALULUT4265549.023
2010CALULUT4265549.024
2010DEL CARMEN6188425.281
2010DEL CARMEN6188425.282
2010DEL CARMEN6188425.283
2010DEL CARMEN6188425.284
2010DEL PILAR5100402.121
2010DEL PILAR5100402.122
2010DEL PILAR5100402.123
2010DEL PILAR5100402.124
2010DEL ROSARIO9397775.481
2010DEL ROSARIO9397775.482
2010DEL ROSARIO9397775.483
2010DEL ROSARIO9397775.484
2010DELA PAZ DUR2022300.21
2010DELA PAZ DUR2022300.22
2010DELA PAZ DUR2022300.23
2010DELA PAZ DUR2022300.24
2010DELA PAZ NORTE4289713.681
2010DELA PAZ NORTE4289713.682
2010DELA PAZ NORTE4289713.683
2010DELA PAZ NORTE4289713.684
2010DOLORES30135092.41
2010DOLORES30135092.42
2010DOLORES30135092.43
2010DOLORES30135092.44
2010JULIANA1766343.921
2010JULIANA1766343.922
2010JULIANA1766343.923
2010JULIANA1766343.924
2010LARA1997332.441
2010LARA1997332.442
2010LARA1997332.443
2010LARA1997332.444
2010LOURDES1988563.621
2010LOURDES1988563.622
2010LOURDES1988563.623
2010LOURDES1988563.624
2010MAGLIMAN3976300.581
2010MAGLIMAN3976300.582
2010MAGLIMAN3976300.583
2010MAGLIMAN3976300.584
2010MAIMPIS15015116.71
2010MAIMPIS15015116.72
2010MAIMPIS15015116.73
2010MAIMPIS15015116.74
2010MALINO1404933.441
2010MALINO1404933.442
2010MALINO1404933.443
2010MALINO1404933.444
2010MALPITIC1367139.481
2010MALPITIC1367139.482
2010MALPITIC1367139.483
2010MALPITIC1367139.484
2010PANDARAS92458.261
2010PANDARAS92458.262
2010PANDARAS92458.263
2010PANDARAS92458.264
2010PANIPUAN4606346.861
2010PANIPUAN4606346.862
2010PANIPUAN4606346.863
2010PANIPUAN4606346.864
2010POBLACION14153801.11
2010POBLACION14153801.12
2010POBLACION14153801.13
2010POBLACION14153801.14
2010PULUNG BULU4065627.331
2010PULUNG BULU4065627.332
2010PULUNG BULU4065627.333
2010PULUNG BULU4065627.334
2010QUEBIAWAN27015699.91
2010QUEBIAWAN27015699.92
2010QUEBIAWAN27015699.93
2010QUEBIAWAN27015699.94
2010SAGUIN96423631
2010SAGUIN96423632
2010SAGUIN96423633
2010SAGUIN96423634
2010SAN AGUSTIN30584203.61
2010SAN AGUSTIN30584203.62
2010SAN AGUSTIN30584203.63
2010SAN AGUSTIN30584203.64
2010SAN FELIPE3533020.881
2010SAN FELIPE3533020.882
2010SAN FELIPE3533020.883
2010SAN FELIPE3533020.884
2010SAN ISIDRO6295223.721
2010SAN ISIDRO6295223.722
2010SAN ISIDRO6295223.723
2010SAN ISIDRO6295223.724
2010SAN JOSE28818077.61
2010SAN JOSE28818077.62
2010SAN JOSE28818077.63
2010SAN JOSE28818077.64
2010SAN JUAN3367561.121
2010SAN JUAN3367561.122
2010SAN JUAN3367561.123
2010SAN JUAN3367561.124
2010SAN NICOLAS2289425.691
2010SAN NICOLAS2289425.692
2010SAN NICOLAS2289425.693
2010SAN NICOLAS2289425.694
2010SAN PEDRO547995.861
2010SAN PEDRO547995.862
2010SAN PEDRO547995.863
2010SAN PEDRO547995.864
2010SINDALAN157682951
2010SINDALAN157682952
2010SINDALAN157682953
2010SINDALAN157682954
2010STA TERESITA461335.61
2010STA TERESITA461335.62
2010STA TERESITA461335.63
2010STA TERESITA461335.64
2010STA. LUCIA2039032.951
2010STA. LUCIA2039032.952
2010STA. LUCIA2039032.953
2010STA. LUCIA2039032.954
2010STO. NIÑO5716091.191
2010STO. NIÑO5716091.192
2010STO. NIÑO5716091.193
2010STO. NIÑO5716091.194
2010TELABASTAGAN16449083.41
2010TELABASTAGAN16449083.42
2010TELABASTAGAN16449083.43
2010TELABASTAGAN16449083.44
2011ALASAS1613488.71
2011ALASAS1613488.72
2011ALASAS1613488.73
2011ALASAS1613488.74
2011BALITI6568081.041
2011BALITI6568081.042
2011BALITI6568081.043
2011BALITI6568081.044
2011BULAON2033106.821
2011BULAON2033106.822
2011BULAON2033106.823
2011BULAON2033106.824
2011CALULUT4265549.021
2011CALULUT4265549.022
2011CALULUT4265549.023
2011CALULUT4265549.024
2011DEL CARMEN6188425.281
2011DEL CARMEN6188425.282
2011DEL CARMEN6188425.283
2011DEL CARMEN6188425.284
2011DEL PILAR5100402.121
2011DEL PILAR5100402.122
2011DEL PILAR5100402.123
2011DEL PILAR5100402.124
2011DEL ROSARIO9397775.481
2011DEL ROSARIO9397775.482
2011DEL ROSARIO9397775.483
2011DEL ROSARIO9397775.484
2011DELA PAZ DUR2022300.21
2011DELA PAZ DUR2022300.22
2011DELA PAZ DUR2022300.23
2011DELA PAZ DUR2022300.24
2011DELA PAZ NORTE4289713.681
2011DELA PAZ NORTE4289713.682
2011DELA PAZ NORTE4289713.683
2011DELA PAZ NORTE4289713.684
2011DOLORES30135092.41
2011DOLORES30135092.42
2011DOLORES30135092.43
2011DOLORES30135092.44
2011JULIANA1766343.921
2011JULIANA1766343.922
2011JULIANA1766343.923
2011JULIANA1766343.924
2011LARA1997332.441
2011LARA1997332.442
2011LARA1997332.443
2011LARA1997332.444
2011LOURDES1988563.621
2011LOURDES1988563.622
2011LOURDES1988563.623
2011LOURDES1988563.624
2011MAGLIMAN3976300.581
2011MAGLIMAN3976300.582
2011MAGLIMAN3976300.583
2011MAGLIMAN3976300.584
2011MAIMPIS15015116.71
2011MAIMPIS15015116.72
2011MAIMPIS15015116.73
2011MAIMPIS15015116.74
2011MALINO1404933.441
2011MALINO1404933.442
2011MALINO1404933.443
2011MALINO1404933.444
2011MALPITIC1367139.481
2011MALPITIC1367139.482
2011MALPITIC1367139.483
2011MALPITIC1367139.484
2011PANDARAS92458.261
2011PANDARAS92458.262
2011PANDARAS92458.263
2011PANDARAS92458.264
2011PANIPUAN4606346.861
2011PANIPUAN4606346.862
2011PANIPUAN4606346.863
2011PANIPUAN4606346.864
2011POBLACION14153801.11
2011POBLACION14153801.12
2011POBLACION14153801.13
2011POBLACION14153801.14
2011PULUNG BULU4065627.331
2011PULUNG BULU4065627.332
2011PULUNG BULU4065627.333
2011PULUNG BULU4065627.334
2011QUEBIAWAN27015699.91
2011QUEBIAWAN27015699.92
2011QUEBIAWAN27015699.93
2011QUEBIAWAN27015699.94
2011SAGUIN96423631
2011SAGUIN96423632
2011SAGUIN96423633
2011SAGUIN96423634
2011SAN AGUSTIN30584203.61
2011SAN AGUSTIN30584203.62
2011SAN AGUSTIN30584203.63
2011SAN AGUSTIN30584203.64
2011SAN FELIPE3533020.881
2011SAN FELIPE3533020.882
2011SAN FELIPE3533020.883
2011SAN FELIPE3533020.884
2011SAN ISIDRO6295223.721
2011SAN ISIDRO6295223.722
2011SAN ISIDRO6295223.723
2011SAN ISIDRO6295223.724
2011SAN JOSE28818077.61
2011SAN JOSE28818077.62
2011SAN JOSE28818077.63
2011SAN JOSE28818077.64
2011SAN JUAN3367561.121
2011SAN JUAN3367561.122
2011SAN JUAN3367561.123
2011SAN JUAN3367561.124
2011SAN NICOLAS2289425.691
2011SAN NICOLAS2289425.692
2011SAN NICOLAS2289425.693
2011SAN NICOLAS2289425.694
2011SAN PEDRO547995.861
2011SAN PEDRO547995.862
2011SAN PEDRO547995.863
2011SAN PEDRO547995.864
2011SINDALAN157682951
2011SINDALAN157682952
2011SINDALAN157682953
2011SINDALAN157682954
2011STA TERESITA461335.61
2011STA TERESITA461335.62
2011STA TERESITA461335.63
2011STA TERESITA461335.64
2011STA. LUCIA2039032.951
2011STA. LUCIA2039032.952
2011STA. LUCIA2039032.953
2011STA. LUCIA2039032.954
2011STO. NIÑO5716091.191
2011STO. NIÑO5716091.192
2011STO. NIÑO5716091.193
2011STO. NIÑO5716091.194
2011TELABASTAGAN16449083.41
2011TELABASTAGAN16449083.42
2011TELABASTAGAN16449083.43
2011TELABASTAGAN16449083.44
2012ALASAS1613488.71
2012ALASAS1613488.72
2012ALASAS1613488.73
2012ALASAS1613488.74
2012BALITI6568081.041
2012BALITI6568081.042
2012BALITI6568081.043
2012BALITI6568081.044
2012BULAON2033106.821
2012BULAON2033106.822
2012BULAON2033106.823
2012BULAON2033106.824
2012CALULUT4265549.021
2012CALULUT4265549.022
2012CALULUT4265549.023
2012CALULUT4265549.024
2012DEL CARMEN6188425.281
2012DEL CARMEN6188425.282
2012DEL CARMEN6188425.283
2012DEL CARMEN6188425.284
2012DEL PILAR5100402.121
2012DEL PILAR5100402.122
2012DEL PILAR5100402.123
2012DEL PILAR5100402.124
2012DEL ROSARIO9397775.481
2012DEL ROSARIO9397775.482
2012DEL ROSARIO9397775.483
2012DEL ROSARIO9397775.484
2012DELA PAZ DUR2022300.21
2012DELA PAZ DUR2022300.22
2012DELA PAZ DUR2022300.23
2012DELA PAZ DUR2022300.24
2012DELA PAZ NORTE4289713.681
2012DELA PAZ NORTE4289713.682
2012DELA PAZ NORTE4289713.683
2012DELA PAZ NORTE4289713.684
2012DOLORES30135092.41
2012DOLORES30135092.42
2012DOLORES30135092.43
2012DOLORES30135092.44
2012JULIANA1766343.921
2012JULIANA1766343.922
2012JULIANA1766343.923
2012JULIANA1766343.924
2012LARA1997332.441
2012LARA1997332.442
2012LARA1997332.443
2012LARA1997332.444
2012LOURDES1988563.621
2012LOURDES1988563.622
2012LOURDES1988563.623
2012LOURDES1988563.624
2012MAGLIMAN3976300.581
2012MAGLIMAN3976300.582
2012MAGLIMAN3976300.583
2012MAGLIMAN3976300.584
2012MAIMPIS15015116.71
2012MAIMPIS15015116.72
2012MAIMPIS15015116.73
2012MAIMPIS15015116.74
2012MALINO1404933.441
2012MALINO1404933.442
2012MALINO1404933.443
2012MALINO1404933.444
2012MALPITIC1367139.481
2012MALPITIC1367139.482
2012MALPITIC1367139.483
2012MALPITIC1367139.484
2012PANDARAS92458.261
2012PANDARAS92458.262
2012PANDARAS92458.263
2012PANDARAS92458.264
2012PANIPUAN4606346.861
2012PANIPUAN4606346.862
2012PANIPUAN4606346.863
2012PANIPUAN4606346.864
2012POBLACION14153801.11
2012POBLACION14153801.12
2012POBLACION14153801.13
2012POBLACION14153801.14
2012PULUNG BULU4065627.331
2012PULUNG BULU4065627.332
2012PULUNG BULU4065627.333
2012PULUNG BULU4065627.334
2012QUEBIAWAN27015699.91
2012QUEBIAWAN27015699.92
2012QUEBIAWAN27015699.93
2012QUEBIAWAN27015699.94
2012SAGUIN96423631
2012SAGUIN96423632
2012SAGUIN96423633
2012SAGUIN96423634
2012SAN AGUSTIN30584203.61
2012SAN AGUSTIN30584203.62
2012SAN AGUSTIN30584203.63
2012SAN AGUSTIN30584203.64
2012SAN FELIPE3533020.881
2012SAN FELIPE3533020.882
2012SAN FELIPE3533020.883
2012SAN FELIPE3533020.884
2012SAN ISIDRO6295223.721
2012SAN ISIDRO6295223.722
2012SAN ISIDRO6295223.723
2012SAN ISIDRO6295223.724
2012SAN JOSE28818077.61
2012SAN JOSE28818077.62
2012SAN JOSE28818077.63
2012SAN JOSE28818077.64
2012SAN JUAN3367561.121
2012SAN JUAN3367561.122
2012SAN JUAN3367561.123
2012SAN JUAN3367561.124
2012SAN NICOLAS2289425.691
2012SAN NICOLAS2289425.692
2012SAN NICOLAS2289425.693
2012SAN NICOLAS2289425.694
2012SAN PEDRO547995.861
2012SAN PEDRO547995.862
2012SAN PEDRO547995.863
2012SAN PEDRO547995.864
2012SINDALAN157682951
2012SINDALAN157682952
2012SINDALAN157682953
2012SINDALAN157682954
2012STA TERESITA461335.61
2012STA TERESITA461335.62
2012STA TERESITA461335.63
2012STA TERESITA461335.64
2012STA. LUCIA2039032.951
2012STA. LUCIA2039032.952
2012STA. LUCIA2039032.953
2012STA. LUCIA2039032.954
2012STO. NIÑO5716091.191
2012STO. NIÑO5716091.192
2012STO. NIÑO5716091.193
2012STO. NIÑO5716091.194
2012TELABASTAGAN16449083.41
2012TELABASTAGAN16449083.42
2012TELABASTAGAN16449083.43
2012TELABASTAGAN16449083.44
2013ALASAS1613488.71
2013ALASAS1613488.72
2013ALASAS1613488.73
2013ALASAS1613488.74
2013BALITI6568081.041
2013BALITI6568081.042
2013BALITI6568081.043
2013BALITI6568081.044
2013BULAON2033106.821
2013BULAON2033106.822
2013BULAON2033106.823
2013BULAON2033106.824
2013CALULUT4265549.021
2013CALULUT4265549.022
2013CALULUT4265549.023
2013CALULUT4265549.024
2013DEL CARMEN6188425.281
2013DEL CARMEN6188425.282
2013DEL CARMEN6188425.283
2013DEL CARMEN6188425.284
2013DEL PILAR5100402.121
2013DEL PILAR5100402.122
2013DEL PILAR5100402.123
2013DEL PILAR5100402.124
2013DEL ROSARIO9397775.481
2013DEL ROSARIO9397775.482
2013DEL ROSARIO9397775.483
2013DEL ROSARIO9397775.484
2013DELA PAZ DUR2022300.21
2013DELA PAZ DUR2022300.22
2013DELA PAZ DUR2022300.23
2013DELA PAZ DUR2022300.24
2013DELA PAZ NORTE4289713.681
2013DELA PAZ NORTE4289713.682
2013DELA PAZ NORTE4289713.683
2013DELA PAZ NORTE4289713.684
2013DOLORES30135092.41
2013DOLORES30135092.42
2013DOLORES30135092.43
2013DOLORES30135092.44
2013JULIANA1766343.921
2013JULIANA1766343.922
2013JULIANA1766343.923
2013JULIANA1766343.924
2013LARA1997332.441
2013LARA1997332.442
2013LARA1997332.443
2013LARA1997332.444
2013LOURDES1988563.621
2013LOURDES1988563.622
2013LOURDES1988563.623
2013LOURDES1988563.624
2013MAGLIMAN3976300.581
2013MAGLIMAN3976300.582
2013MAGLIMAN3976300.583
2013MAGLIMAN3976300.584
2013MAIMPIS15015116.71
2013MAIMPIS15015116.72
2013MAIMPIS15015116.73
2013MAIMPIS15015116.74
2013MALINO1404933.441
2013MALINO1404933.442
2013MALINO1404933.443
2013MALINO1404933.444
2013MALPITIC1367139.481
2013MALPITIC1367139.482
2013MALPITIC1367139.483
2013MALPITIC1367139.484
2013PANDARAS92458.261
2013PANDARAS92458.262
2013PANDARAS92458.263
2013PANDARAS92458.264
2013PANIPUAN4606346.861
2013PANIPUAN4606346.862
2013PANIPUAN4606346.863
2013PANIPUAN4606346.864
2013POBLACION14153801.11
2013POBLACION14153801.12
2013POBLACION14153801.13
2013POBLACION14153801.14
2013PULUNG BULU4065627.331
2013PULUNG BULU4065627.332
2013PULUNG BULU4065627.333
2013PULUNG BULU4065627.334
2013QUEBIAWAN27015699.91
2013QUEBIAWAN27015699.92
2013QUEBIAWAN27015699.93
2013QUEBIAWAN27015699.94
2013SAGUIN96423631
2013SAGUIN96423632
2013SAGUIN96423633
2013SAGUIN96423634
2013SAN AGUSTIN30584203.61
2013SAN AGUSTIN30584203.62
2013SAN AGUSTIN30584203.63
2013SAN AGUSTIN30584203.64
2013SAN FELIPE3533020.881
2013SAN FELIPE3533020.882
2013SAN FELIPE3533020.883
2013SAN FELIPE3533020.884
2013SAN ISIDRO6295223.721
2013SAN ISIDRO6295223.722
2013SAN ISIDRO6295223.723
2013SAN ISIDRO6295223.724
2013SAN JOSE28818077.61
2013SAN JOSE28818077.62
2013SAN JOSE28818077.63
2013SAN JOSE28818077.64
2013SAN JUAN3367561.121
2013SAN JUAN3367561.122
2013SAN JUAN3367561.123
2013SAN JUAN3367561.124
2013SAN NICOLAS2289425.691
2013SAN NICOLAS2289425.692
2013SAN NICOLAS2289425.693
2013SAN NICOLAS2289425.694
2013SAN PEDRO547995.861
2013SAN PEDRO547995.862
2013SAN PEDRO547995.863
2013SAN PEDRO547995.864
2013SINDALAN157682951
2013SINDALAN157682952
2013SINDALAN157682953
2013SINDALAN157682954
2013STA TERESITA461335.61
2013STA TERESITA461335.62
2013STA TERESITA461335.63
2013STA TERESITA461335.64
2013STA. LUCIA2039032.951
2013STA. LUCIA2039032.952
2013STA. LUCIA2039032.953
2013STA. LUCIA2039032.954
2013STO. NIÑO5716091.191
2013STO. NIÑO5716091.192
2013STO. NIÑO5716091.193
2013STO. NIÑO5716091.194
2013TELABASTAGAN16449083.41
2013TELABASTAGAN16449083.42
2013TELABASTAGAN16449083.43
2013TELABASTAGAN16449083.44
2014ALASAS1613488.71
2014ALASAS1613488.72
2014ALASAS1613488.73
2014ALASAS1613488.74
2014BALITI6568081.041
2014BALITI6568081.042
2014BALITI6568081.043
2014BALITI6568081.044
2014BULAON2033106.821
2014BULAON2033106.822
2014BULAON2033106.823
2014BULAON2033106.824
2014CALULUT4265549.021
2014CALULUT4265549.022
2014CALULUT4265549.023
2014CALULUT4265549.024
2014DEL CARMEN6188425.281
2014DEL CARMEN6188425.282
2014DEL CARMEN6188425.283
2014DEL CARMEN6188425.284
2014DEL PILAR5100402.121
2014DEL PILAR5100402.122
2014DEL PILAR5100402.123
2014DEL PILAR5100402.124
2014DEL ROSARIO9397775.481
2014DEL ROSARIO9397775.482
2014DEL ROSARIO9397775.483
2014DEL ROSARIO9397775.484
2014DELA PAZ DUR2022300.21
2014DELA PAZ DUR2022300.22
2014DELA PAZ DUR2022300.23
2014DELA PAZ DUR2022300.24
2014DELA PAZ NORTE4289713.681
2014DELA PAZ NORTE4289713.682
2014DELA PAZ NORTE4289713.683
2014DELA PAZ NORTE4289713.684
2014DOLORES30135092.41
2014DOLORES30135092.42
2014DOLORES30135092.43
2014DOLORES30135092.44
2014JULIANA1766343.921
2014JULIANA1766343.922
2014JULIANA1766343.923
2014JULIANA1766343.924
2014LARA1997332.441
2014LARA1997332.442
2014LARA1997332.443
2014LARA1997332.444
2014LOURDES1988563.621
2014LOURDES1988563.622
2014LOURDES1988563.623
2014LOURDES1988563.624
2014MAGLIMAN3976300.581
2014MAGLIMAN3976300.582
2014MAGLIMAN3976300.583
2014MAGLIMAN3976300.584
2014MAIMPIS15015116.71
2014MAIMPIS15015116.72
2014MAIMPIS15015116.73
2014MAIMPIS15015116.74
2014MALINO1404933.441
2014MALINO1404933.442
2014MALINO1404933.443
2014MALINO1404933.444
2014MALPITIC1367139.481
2014MALPITIC1367139.482
2014MALPITIC1367139.483
2014MALPITIC1367139.484
2014PANDARAS92458.261
2014PANDARAS92458.262
2014PANDARAS92458.263
2014PANDARAS92458.264
2014PANIPUAN4606346.861
2014PANIPUAN4606346.862
2014PANIPUAN4606346.863
2014PANIPUAN4606346.864
2014POBLACION14153801.11
2014POBLACION14153801.12
2014POBLACION14153801.13
2014POBLACION14153801.14
2014PULUNG BULU4065627.331
2014PULUNG BULU4065627.332
2014PULUNG BULU4065627.333
2014PULUNG BULU4065627.334
2014QUEBIAWAN27015699.91
2014QUEBIAWAN27015699.92
2014QUEBIAWAN27015699.93
2014QUEBIAWAN27015699.94
2014SAGUIN96423631
2014SAGUIN96423632
2014SAGUIN96423633
2014SAGUIN96423634
2014SAN AGUSTIN30584203.61
2014SAN AGUSTIN30584203.62
2014SAN AGUSTIN30584203.63
2014SAN AGUSTIN30584203.64
2014SAN FELIPE3533020.881
2014SAN FELIPE3533020.882
2014SAN FELIPE3533020.883
2014SAN FELIPE3533020.884
2014SAN ISIDRO6295223.721
2014SAN ISIDRO6295223.722
2014SAN ISIDRO6295223.723
2014SAN ISIDRO6295223.724
2014SAN JOSE28818077.61
2014SAN JOSE28818077.62
2014SAN JOSE28818077.63
2014SAN JOSE28818077.64
2014SAN JUAN3367561.121
2014SAN JUAN3367561.122
2014SAN JUAN3367561.123
2014SAN JUAN3367561.124
2014SAN NICOLAS2289425.691
2014SAN NICOLAS2289425.692
2014SAN NICOLAS2289425.693
2014SAN NICOLAS2289425.694
2014SAN PEDRO547995.861
2014SAN PEDRO547995.862
2014SAN PEDRO547995.863
2014SAN PEDRO547995.864
2014SINDALAN157682951
2014SINDALAN157682952
2014SINDALAN157682953
2014SINDALAN157682954
2014STA TERESITA461335.61
2014STA TERESITA461335.62
2014STA TERESITA461335.63
2014STA TERESITA461335.64
2014STA. LUCIA2039032.951
2014STA. LUCIA2039032.952
2014STA. LUCIA2039032.953
2014STA. LUCIA2039032.954
2014STO. NIÑO5716091.191
2014STO. NIÑO5716091.192
2014STO. NIÑO5716091.193
2014STO. NIÑO5716091.194
2014TELABASTAGAN16449083.41
2014TELABASTAGAN16449083.42
2014TELABASTAGAN16449083.43
2014TELABASTAGAN16449083.44
2015ALASAS1613488.71
2015ALASAS1613488.72
2015ALASAS1613488.73
2015ALASAS1613488.74
2015BALITI6568081.041
2015BALITI6568081.042
2015BALITI6568081.043
2015BALITI6568081.044
2015BULAON2033106.821
2015BULAON2033106.822
2015BULAON2033106.823
2015BULAON2033106.824
2015CALULUT4265549.021
2015CALULUT4265549.022
2015CALULUT4265549.023
2015CALULUT4265549.024
2015DEL CARMEN6188425.281
2015DEL CARMEN6188425.282
2015DEL CARMEN6188425.283
2015DEL CARMEN6188425.284
2015DEL PILAR5100402.121
2015DEL PILAR5100402.122
2015DEL PILAR5100402.123
2015DEL PILAR5100402.124
2015DEL ROSARIO9397775.481
2015DEL ROSARIO9397775.482
2015DEL ROSARIO9397775.483
2015DEL ROSARIO9397775.484
2015DELA PAZ DUR2022300.21
2015DELA PAZ DUR2022300.22
2015DELA PAZ DUR2022300.23
2015DELA PAZ DUR2022300.24
2015DELA PAZ NORTE4289713.681
2015DELA PAZ NORTE4289713.682
2015DELA PAZ NORTE4289713.683
2015DELA PAZ NORTE4289713.684
2015DOLORES30135092.41
2015DOLORES30135092.42
2015DOLORES30135092.43
2015DOLORES30135092.44
2015JULIANA1766343.921
2015JULIANA1766343.922
2015JULIANA1766343.923
2015JULIANA1766343.924
2015LARA1997332.441
2015LARA1997332.442
2015LARA1997332.443
2015LARA1997332.444
2015LOURDES1988563.621
2015LOURDES1988563.622
2015LOURDES1988563.623
2015LOURDES1988563.624
2015MAGLIMAN3976300.581
2015MAGLIMAN3976300.582
2015MAGLIMAN3976300.583
2015MAGLIMAN3976300.584
2015MAIMPIS15015116.71
2015MAIMPIS15015116.72
2015MAIMPIS15015116.73
2015MAIMPIS15015116.74
2015MALINO1404933.441
2015MALINO1404933.442
2015MALINO1404933.443
2015MALINO1404933.444
2015MALPITIC1367139.481
2015MALPITIC1367139.482
2015MALPITIC1367139.483
2015MALPITIC1367139.484
2015PANDARAS92458.261
2015PANDARAS92458.262
2015PANDARAS92458.263
2015PANDARAS92458.264
2015PANIPUAN4606346.861
2015PANIPUAN4606346.862
2015PANIPUAN4606346.863
2015PANIPUAN4606346.864
2015POBLACION14153801.11
2015POBLACION14153801.12
2015POBLACION14153801.13
2015POBLACION14153801.14
2015PULUNG BULU4065627.331
2015PULUNG BULU4065627.332
2015PULUNG BULU4065627.333
2015PULUNG BULU4065627.334
2015QUEBIAWAN27015699.91
2015QUEBIAWAN27015699.92
2015QUEBIAWAN27015699.93
2015QUEBIAWAN27015699.94
2015SAGUIN96423631
2015SAGUIN96423632
2015SAGUIN96423633
2015SAGUIN96423634
2015SAN AGUSTIN30584203.61
2015SAN AGUSTIN30584203.62
2015SAN AGUSTIN30584203.63
2015SAN AGUSTIN30584203.64
2015SAN FELIPE3533020.881
2015SAN FELIPE3533020.882
2015SAN FELIPE3533020.883
2015SAN FELIPE3533020.884
2015SAN ISIDRO6295223.721
2015SAN ISIDRO6295223.722
2015SAN ISIDRO6295223.723
2015SAN ISIDRO6295223.724
2015SAN JOSE28818077.61
2015SAN JOSE28818077.62
2015SAN JOSE28818077.63
2015SAN JOSE28818077.64
2015SAN JUAN3367561.121
2015SAN JUAN3367561.122
2015SAN JUAN3367561.123
2015SAN JUAN3367561.124
2015SAN NICOLAS2289425.691
2015SAN NICOLAS2289425.692
2015SAN NICOLAS2289425.693
2015SAN NICOLAS2289425.694
2015SAN PEDRO547995.861
2015SAN PEDRO547995.862
2015SAN PEDRO547995.863
2015SAN PEDRO547995.864
2015SINDALAN157682951
2015SINDALAN157682952
2015SINDALAN157682953
2015SINDALAN157682954
2015STA TERESITA461335.61
2015STA TERESITA461335.62
2015STA TERESITA461335.63
2015STA TERESITA461335.64
2015STA. LUCIA2039032.951
2015STA. LUCIA2039032.952
2015STA. LUCIA2039032.953
2015STA. LUCIA2039032.954
2015STO. NIÑO5716091.191
2015STO. NIÑO5716091.192
2015STO. NIÑO5716091.193
2015STO. NIÑO5716091.194
2015TELABASTAGAN16449083.41
2015TELABASTAGAN16449083.42
2015TELABASTAGAN16449083.43
2015TELABASTAGAN16449083.44
2 Replies
MVP
MVP

Re: sum of total receivable per year and per quarter

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
Valued Contributor III