Pivot Tables - Calculated Item

W

william.mcseveney

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
 
B

Barb Reinhardt

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.
 
Top