Have you looked at the GetPivotData function? You can replace some of the
hard coded values with something like "A1" where A1 contains the value you
need.
--
HTH,
Barb Reinhardt



" wrote:

Hi

I have a calculated item formula which uses the sum function. It
selects certain columns to sum up. The problem I have is that these
categories I need to sum up change each day, which means I have to
manually select the columns to add up - which is time consuming.

How could I get around this problem?

Thanks


W