LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27
Default Auto filtering pivot table field

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,
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table page field filtering murkaboris Excel Discussion (Misc queries) 2 December 19th 08 01:47 AM
Pivot Table - Filtering Data Field Mark Excel Discussion (Misc queries) 3 May 29th 07 05:16 PM
Pivot table auto field selection JohnC Excel Programming 2 February 27th 07 11:26 AM
How to make a field created a part of the Pivot Table Field List? drhell Excel Discussion (Misc queries) 0 January 29th 07 11:13 PM
Pivot Table - Filtering Page Field R. G. Ingersoll Excel Discussion (Misc queries) 1 January 29th 05 07:29 PM


All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"