Calculated Field in Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have alist of data in columns
column A = Category
column B = subcategory
Column C = taxable (True/False)
i have other fields that are not crucial to this question. i have set up a
pivot table to view the data by category. i want to add a coolumn, or
calculated field, showing the amount of tax @ 7.5% for the items that are
taxable. can you use if/then statements in pivot tables?
 
You could create a calculated item for the tax:

Select the field button for the Taxable field
From the Pivot toolbar, choose PivotTable>Formulas>Calculated Item
Type a name, e.g. Tax
Type a formula: ='TRUE'*0.075
Click OK

Note: This will create a calculated item for each subcategory in the
pivot table. You may prefer to calculate the tax in your source data,
and add that field to the pivot table.
 

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

How to ignore a column of numbers in Grand Total for rows 1
grouping dates in pivot table: calculated field? 2
help calculating tax and total in pivot chart 2
Pivot Table: new column with a calculation 1
2007 Pivot table Calculated field misbehaving 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Subtotal percents in pivot table 1
Calculated Item in Pivot table 1

Back
Top