I’ve created a Commissions Forecast metric to calculate the difference between YTD Commissions and Total Target Commissions. The value is then spread over the remaining months left in the current year.
I’d like to maintain the values from this metric and have it to flow through to my Total Compensation metric which has more dimensions defined in the metric structure. Any tips on how to accomplish this?
Commissions Forecast Metric Dimensions: Department, Month
Total Compensation Metric Dimensions: Department, Month, ID, Employment Type, Employment Status, Location, State.
Best answer by KylaView original