Hi,
I want a monthly report sum of the customer.my data is below, How can I do that
You should create a column “Month”.
I have created that VC also , But i want sum of each customer monthly
This should be good reference point for you.
[I want to chart values by day, week, month and year](https://community.appsheet.com/t/i-want-to-chart-values-by-day-week-month-and-year/27178/4) Questions
Histgram chart should be the one that solve your proglam as well as achieve your goal, I suppose. My understanding to your requirement, if i m correct, is you want to aggregate the row / fields value from day/date level to mm/yyyy level and render chart in that way? for instance, the chart will display the sum of each mm/yyyy for the price fields in aggregation. There are few workaround to achieve it. It is bit complex, and should be benefit to share the trick in the community for the benefit…
2 Likes
Sir
But i want to download the data monthly for sending the report
Refer to my sample app I shared to the public. There is calendar table, which will do the aggregation calc. One row represent YYYY MM. This stands as parent record, where we have associated records as child.
set up aciton and workflow on this calendar table to get the data basis per yyyy mm.
You need to be ready to get your hands dirty.
3 Likes