Pivot Tables - Calculated Item

  • Thread starter Thread starter william.mcseveney
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table, IF function, calculated item versus calculated field 1
Average of % in pivot table 1
Pivot Table Calculated field error 1
Calculated field in Pivot Table 2
Headings for Sum in Pivot Table. 5
Trailing 30 days sum calculation with excel 1
How to Show SUM of field value in other column 4
Formulas in Pivot Table 4

Back
Top