Pinterest Pixel

List Calculated Field and Item formulas

Pivot Table Calculated Fields allow you to do mathematical calculations with your Field List and Calculated Items... read more

Download Excel Workbook
Bryan
Posted on

Overview

List Calculated Field and Item formulas | MyExcelOnline

Pivot Table Calculated Fields allow you to do mathematical calculations with your Field List and Calculated Items allow you to do mathematical calculations with your Item List. You can use any of the Excel mathematical equations, like /*+-%.

When working with Calculated Fields and Items, it can sometimes get cumbersome to have a quick snapshot of all of them, so that you can quickly check for errors.

Luckily, there is a feature in Excel that can list calculated fields and items for you in one place!

This list will show all the calculated fields and items saved in Pivot Table’s cache, irrespective of whether they are currently being used in the workbook.

 

Before we proceed, you can download the Exercise Workbook below and follow along with us!

download excel workbookList-Calculated-Field-Item-formulas.xlsx


Here is our current Pivot Table and our Calculated Items:

List Calculated Field and Item formulas

 

Follow the steps below to list calculated fields and items present in the selected Pivot Table in a new worksheet:

See also  Copy a custom style into a new workbook

STEP 1: Click anywhere on the Pivot Table.

List Calculated Field and Item formulas

STEP 2: Go to PivotTable Analyze > Fields, Items & Sets > List Formulas

List Calculated Field and Item formulas

 

With just one click, all of the Calculated Fields and Items are listed in a new worksheet!

List Calculated Field and Item formulas

At first, all the calculated fields will be listed and after that, the calculated items’ list will be shown. You can easily go through all the formulas here and check for errors if any.

You can learn more about Calculated Fields and Calculated Items by reading our blog and watching our YouTube channel.

 

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

List Calculated Field and Item formulas | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!