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?
Bookmarks