Hello,
I have a pivot table that has ranges of number of units. I would like to use this field for looking up a value in that range to return the average number of minutes for that unit range.
So I am going to have another column that will have values to get summed ie 50+50+100+250=450. I then would like to use that 450 value to lookup in the units column of the above table, find the cell, and then return the average minutes for that unit range. I know there are probably different ways of doing this I just wanted to avoid making two columns for the unit range and just use the pivot table ranges.
Look forward to the creative solutions,
Mack
I have a pivot table that has ranges of number of units. I would like to use this field for looking up a value in that range to return the average number of minutes for that unit range.
So I am going to have another column that will have values to get summed ie 50+50+100+250=450. I then would like to use that 450 value to lookup in the units column of the above table, find the cell, and then return the average minutes for that unit range. I know there are probably different ways of doing this I just wanted to avoid making two columns for the unit range and just use the pivot table ranges.
Look forward to the creative solutions,
Mack