Hello:
Please refer to attached file.
I have data is Sheet1 and i have created Pivot Table.
I need to eliminate displaying all data wild char *-x in Column B.
Let me know if you have any questions.
Thanks.
Riz
Hello:
Please refer to attached file.
I have data is Sheet1 and i have created Pivot Table.
I need to eliminate displaying all data wild char *-x in Column B.
Let me know if you have any questions.
Thanks.
Riz
I feel as if I have to be missing something, however it would seem as if deselecting -x and -xx at the bottom of the filter list for the ID column would accomplish what you want.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi riz,
Is this what you need?
PivotTable Not Contain Row Filter 4 Riz.xlsb
Right click in column B in your PT and then on Filter and then on Label Filter. Use the dropdown on the "Label Filter (ID)" dialog and see if this doesn't get you what you need.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks