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.
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.
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |