Forum Discussion
I need help finishing my spreadsheet.
I could fuel up as many times as 7 in a week. Each fuel has 3 elements Truck, reefer, and def. Truck and Reefer cost the same. Def is cheaper. Each time I fuel there is varying amounts and varying co...
Hi Eric,
First you shall organize your source data as connected to dates. Other words have tables against dates for your mileage, fuel purchases, earnings, etc. Ideally for each day when you drive (for mileage) or transaction happens, but that could be summary for few days.
After that most universal solution is to build the data model using Power Query/Power View adding the measures you need and summarise them by Pivot Tables for weekly/monthly/annual periods.
Alternatively you may build your summary by formulas separately for weeks, months and years. In the attached file Sheet2 few formulas for weekly stats, the rest is similar.
