I have a Pivot Table, and would like a calculated column based on filter values. For instance, if the user selects a value, say "Generic", I want to discount the sale price by 10%. But if the user selects brand, I want a column for sale price that equals sale price x 85%.
This is an example of course...this scenario doesn't have the be used.
Can you create dynamic fields in a pivot table?