Pivot Table - Calculated Item

  • Thread starter Thread starter Nigel
  • Start date Start date
N

Nigel

I have greated a calculated item to sum the first three months of the year as
Qtr1. Is there a way to edit this formula.

Thanks

Nigel
 
Yes, you can select one of the item headings, then on the PivotTable
toolbar, click PivotTable>Formulas>Calculated Item
From the Name dropdown list, select the item that you want to edit
Change the formula, then click Modify, and click OK.
 
Apologies for the delay in thanking you as I've been away from my PC.

Nigel
 
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
filtering the pivot table..! 1
Countif or sumif for cumulative sums,pivot table & chart 2
Pivot Table 4
Problem with Calculated item in Pivot Table 1
Total Not Summing Correctly on Calculated Fields in Pivot Table 0
Calculated Item causes undue repitition in pivot table 2
Calculate % variance on previous quarters. Quarter %, etc. pivot 1

Back
Top