HTD Weighted Average Calculation based on months completed

Process to calculate HTD Weighted average: 1. Need to create the weighting period based on the no of months completed with in "Half Year". 2. Multiply the sales measure with Weighting period (Sales...