5 Replies Latest reply: Jun 8, 2015 9:37 AM by Sunny Talwar

# How to generate the Sum of Receivable per year on chart?

Hi,

I'm having a trouble on how to display the Sum of Receivables per Year on chart.

Can someone explain me how to do it? Here is the data of my tables.

YearBaranggay NameBaranggay CodeRecivables
2009ALASAS21613488.7
2009ALASAS21613488.7
2009ALASAS21613488.7
2009ALASAS21613488.7
2009BALITI36568081.04
2009BALITI36568081.04
2009BALITI36568081.04
2010BALITI36568081.04
2010BULAON42033106.82
2010BULAON42033106.82
2010BULAON42033106.82
2010BULAON42033106.82
2010CALULUT54265549.02
2010CALULUT54265549.02
2010CALULUT54265549.02
2011CALULUT54265549.02
2011DEL CARMEN86188425.28

• ###### Re: How to generate the Sum of Receivable per year on chart?

Hello!

sum(Receivables)/count(distinct Year)

• ###### Re: How to generate the Sum of Receivable per year on chart?

thank for the help, I will try it later.

• ###### Re: How to generate the Sum of Receivable per year on chart?

Not sure what your desired output is. Would you be able to explain a little bit more?

Best,

Sunny

• ###### Re: How to generate the Sum of Receivable per year on chart?

I want to display the total sum of receivable per year on the chart using the table i posted.

• ###### Re: How to generate the Sum of Receivable per year on chart?

Are you looking for one of the two outputs from the below attached image?

Dimension: Year

Expression 1: =Sum(Recivables)

Expression 2: =Sum(Aggr(Avg(Recivables), Year, [Baranggay Code]))

Also attaching the qvw document for your reference.

HTH

Best,

Sunny