Hi,
Is there any way to use some of the auto filter options (such as begins with
or ends with) in masking a pivot table field?
I have fields containing GL codes and I want to group using the beginning of
the code:
e.g. 100000, 110000, 101000, 200000, etc... I want to be able to see all
fields starting with 1 or with 2 etc...
Can any one help in that?
Thanks,