I want to create a calculated dimension which shows the Minimum date and another calculated dimension which shows maximum date.
In the data for each person a Fromdate and Todate is generated, whenever he booked the contract and ended that contract.
Eg- ID 1011 has many from and todates, and because of that Amount is repeated.
Eg- Similarly in ID , 1146 the amount is repeated everytime there is different from and todate
I am not interested in all the line items, but only the begining FromDate and final ToDate of the whole contract. So that i can only see one total Amount.
To achieve this, i think i have to create a calculated dimension.
