How do I change the order between fields and items in Pivot T?

  • Thread starter Thread starter Sergio Hernandez
  • Start date Start date
S

Sergio Hernandez

I have calculated field on a Pivot Table, and then I have a calculated item
that uses the information previously calculated. My problem is that the PT
calculates the item first, and then the field. How can I change that order?
(first field and the item) Because in the "solve order" option, you can only
make changes between items, but not between items and fields.

SH
 
Hi,

All the control you have of Calculation order in a pivot table is done as
follows
Place your cursor in the pivot table and choose Pivot Table, Formulas, Sort
Order, then select the formula you want to calculate first and move it up or
select any formula and move it up or down as desired.

Remember, you don't have complete control of how and when your formulas
calculate.
 

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 Field based on two data area fields 3
Using Mid Function with Pivot Table Calculated Item 0
Calculated Item in Pivot table 1
Calculate # days from today in a Pivot Table 10
Pivot: Calculated Field vs Calculated Item 2
Pivot Table: new column with a calculation 1
Pivot Item Displaying Incorrect Value? 1
Calculate Average in pivot item 6

Back
Top