Hello,
So I have a pivot table with a list of 500 clients and each have around 4 groups. Is there anyway when I'm filtering the client in then only shows the groups for that client in the group filter.
Thanks
Hello,
So I have a pivot table with a list of 500 clients and each have around 4 groups. Is there anyway when I'm filtering the client in then only shows the groups for that client in the group filter.
Thanks
You can add column with gropus, like:
Group1
Group1
Group2
Group2
Group3
Group3
and add this column as first in PT then filter by groups or easier: add groups to the PT filter field
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks