cogswel__cogs
Board Regular
- Joined
- Jan 3, 2018
- Messages
- 175
I am using a classic pivot table.
One of the rows fields houses diagnosis codes.
On data there are many column that this code could hit so I summarize all in one filed in the data.
This is the rows field with all the combination of diagnosis codes for each record
Then if anyone wants to se pivot just with a particular diagnosis they can filter in the filter box type code and hit return and it filters any with summarized line that code.
I know the triangle changes to funnel but really think group I am doing this for might miss that and sometimes view numbers incorrectly forgetting to reset or not realizing someone had chosen a particular code(s).
Is there a non vba way to highlight cell where the filter selector is so that if it is funnel instead of triangle.
.
All helps greatly appreciated.
One of the rows fields houses diagnosis codes.
On data there are many column that this code could hit so I summarize all in one filed in the data.
This is the rows field with all the combination of diagnosis codes for each record
Then if anyone wants to se pivot just with a particular diagnosis they can filter in the filter box type code and hit return and it filters any with summarized line that code.
I know the triangle changes to funnel but really think group I am doing this for might miss that and sometimes view numbers incorrectly forgetting to reset or not realizing someone had chosen a particular code(s).
Is there a non vba way to highlight cell where the filter selector is so that if it is funnel instead of triangle.
.
All helps greatly appreciated.
