Share
ReportHi Team,
I have a collection like this :
| Plate | Month | Cost |
| FRT-896 | October | 11000 |
| POK-310 | October | 10000 |
| QSE-325 | November | 9000 |
| LKI-963 | November | 7000 |
| FRT-896 | August | 8000 |
| FRT-896 | August | 10000 |
| QSE-325 | September | 12000 |
| QSE-325 | September | 13000 |
| FRT-896 | September | 5000 |
and it´s possible to get this:
| Plate | August | September | October | November |
| FRT-896 | 18000 | 5000 | 11000 | |
| POK-310 | 10000 | |||
| QSE-325 | 25000 | 9000 | ||
| LKI-963 | 7000 |
I used : ClearCollect(Col_Expenses, GroupBy( FullExpenses,"Month","Monthly" ) )
...but only sum the month as total by month, and not like the 2nd table.
any idea ?
Tks in advance guys!
Categories:
I have the same question (0)
All responses (
Answers (
633
