What is the difference beteween a label filter and a value filter?
I have a pivot table which filters on a field list. There is a filter icon on the 'Type' field. When I open the filter to view there is a Label & Value filter listed. What is the difference between these two types and how are they enabled or disabled?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Label filters filter particular items in the row or column field, whereas value filters only filter based on the data fields.
ASKER
Under label & value filters, Where does the select all column derive from?
I don't know what you mean?
Select All literally means select all the items shown beneath it.
ASKER
I am not a pivot table guru by any means. But regarding the "select all" what is its purpose and how was it created?
It's built in to the pivot table and is there to enable you to select (or deselect) all items quickly without having to manually select every one.
Value filters: filter by a value
for example below group1, group2 group3 are Labels. 1000,2000, 3000 etc are values
group1
1000
2000
3000
group2
4000
1000
group3
20000
10000
group4
So if you filter by Label equal to group1 you wull see:
group1
1000
2000
3000
If then you also group by value equal to 1000 you will have
group1
1000