View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] william.mcseveney@ntlworld.com is offline
external usenet poster
 
Posts: 14
Default Pivot Tables - Calculated Item

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