Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak ,

    I checked the topic but I want to group on years instead of averaging out the costs between start and enddate over the time..