Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculated Field in Pivot Table
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? |
#2
|
|||
|
|||
You could create a calculated item for the tax:
Select the field button for the Taxable field From the Pivot toolbar, choose PivotTableFormulasCalculated 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. Spencer Hutton wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
Calculated Field in Pivot Table | Excel Worksheet Functions | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) |