Primary key "Date (Month)" in sorting for user report
It might be helpfull to get a overview of the monthly costs to enable a primary sorting not only for a day, but furthermore for a month in addition to the monthly subtotal. So you can see the total costs of e.g. you insurance for every month directly followed by the refuel costs, even though they have charged it from your depot on different days:
E.g.
01.01. - insurance1 - depot:insurance - xx.xx €
03.01. - shell - depot:refuelCar - zz.zz €
04.01. - insurance2 - depot:insurance - yy.yy €
01.02. - insurance1 - depot:insurance - xx.xx €
...
For the report it should look like:
Primary Key: Date (Month)
Secondary Key: Depot
Result:
January
Insurance
- 01.01 insurance1: xx.xx €
- 04.01 insurance2: yy.yy €
shell
- 03.01 refuel: zz.zz €
February
Insurance
- 01.02 insurance1: xx.xx €
At the moment it will sort like this:
January
Insurance
- 01.01 insurance1: xx.xx €
shell
- 03.01 refuel: zz.zz €
Insurance
- 04.01 insurance2: yy.yy €
February
Insurance
- 01.02 insurance1: xx.xx €
I don't want the depot as the primary key, cause you will have all insurance for the whole year.
Thank you for your request.
However, as far as I can see this can already be accomplished with the current sort options.
Here is how:
Primary sort key: Date
Uncheck primary subtotal
Secondary sort key: Depot
Check secondary subtotal
Set secondary subtotal for date key to “Monthly”