Value Filter in a Pivot Table.
I am trying to apply a value filter in a pivot table, but the options are
greyed out. Why could this be. The scenerio, I have a huge file, with client data. I want to see this data broken down 1st by Sales Manager, 2nd by client. I can get this far. Now I would only like to see data for "Total" sales over 100K. The value filter is not available. |
Value Filter in a Pivot Table.
Deb wrote:
I am trying to apply a value filter in a pivot table, but the options are greyed out. Why could this be. The scenerio, I have a huge file, with client data. I want to see this data broken down 1st by Sales Manager, 2nd by client. I can get this far. Now I would only like to see data for "Total" sales over 100K. The value filter is not available. Of all the crazy coincidences... I was scratching my head over this last night, convinced there must be a way to filter aggregate PT values, and became convinced there is no way. Then, merely hours later, Jon Peltier posted this on his blog: http://peltiertech.com/WordPress/autofilter-tricks/ Works exactly as you asked. |
All times are GMT +1. The time now is 07:42 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com