Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a pivot table which has a few dimensions. I need to use the value of one of these to calculate another one.
Eg
dimension 1 = min(a1)
dimension 2 = $ nnn corresponding to min(a1)
Does anyone have a suggestion?
Well, as far as I know the only way you can do this is by reentering the entire previous dimension into your second dimension. I think you should consider moving the logic for the first dimension to the load script...
Regards,