Forum Discussion
First and second year costs after start date contract
Hi all, I have the following challenge: Table1: ContractNr | StartDate | EndDate Table2: ContractNr | Customer | Costs Desired result (ContractNr as slicer): | Sum of Costs ...
Jihwan_Kim Hi there, thanks for your answer.
I have the same report at the moment but I want to group it by first year cost. So if the contract starts 5-3-20, then first year should group all the cost from 5-3-20 to 5-3-21. Etc for other contracts which all have a different starting date. In that way we can compare the first year costs over the contracts.
Hopefully you can understand what i'm trying to do :).
Jihwan_Kim
Super User
Super UserHi,
I am not quite sure if I understood correctly, and I don't think my sample suits your case.
Because the cost in my sample only shows year granularity.
Or,
Do you want to do something like cohort grouping?