topic how to summarize the monthly turnover in App Development

how to summarize the monthly turnover

buttonmaker — Sat, 16 Oct 2021 09:07:11 GMT

Hi all,
seems, that I have a quite common case here, but I have not found a solution here yet:
I have a table of sales per year and month

I'm looking for a solution to count the numbers in last column of below table

This column should summarize the monthly sales of the current year

I've tried this, but can't get the expected result:

sum(Aggr(Sum(WARENWERT), [BESTELDATUM.autoCalendar.YearMonth]))

Many thanks for your proposals

rubenmarin — Sun, 17 Oct 2021 09:43:17 GMT

Hi, with this script:

tmpData: LOAD * Inline [ year,month,order,order amount 2021,Jan,123,250 2021,Jan,234,300 2021,Feb,345,200 2021,Feb,456,400 2021,MAR,567,150 ]

This expression returns the values accumulated by month:

RangeSum(Above(TOTAL If(month=Above(TOTAL month),0,sum(TOTAL <month> [order amount])),0,RowNo(TOTAL)))

buttonmaker — Sun, 17 Oct 2021 16:31:08 GMT

Hi many thanks. This will summarize the amounts over ALL years. Have an Ide, how to generate the sum per year?

rubenmarin — Sun, 17 Oct 2021 18:33:59 GMT

Hi, maybe this? : RangeSum(Above(TOTAL If(month=Above(TOTAL month),0,sum(TOTAL <year,month> [order amount])),0,RowNo(TOTAL)))