I am trying to calculate a total price within a chart table when the unit price depends on two aggregated values(volume & service level). The unit price is the same across all units so I just need a way of using the aggregated values to look up a reference table but there doesn't seem to be a chart function to do this? "Lookup()" would be ideal but it is only available as a script function.
Can anyone suggest a suitable chart function or an alternative approach?
