Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by andyzauk

  1. andyzauk

    Trying to count pivot items on screen

    Thanks, took a while but I got there. Andy.
  2. andyzauk

    Trying to count pivot items on screen

    Again, when I say it returns all 13 items I mean it returns the count! The number 13. I want it to return the number 5. Andy.
  3. andyzauk

    Trying to count pivot items on screen

    I'm really not sure how I can make my problem any clearer, sorry! I really want to try and get it right, so I'll start from scratch. I'm building a pivot table with a dataset with the following column headings: Fiscal year/period Cost Center Cost Centre Name Cost Element Cost Element Name...
  4. andyzauk

    Trying to count pivot items on screen

    Hi. Sorry, I meant it returns the count of the items on the screen. I realise this question is a bit confusing - I tried to get it out in such a rush. I have a dataset for a full year with which I build a pivot table. One of the fields is "Cost Buckets". There are 13 cost buckets altogether in...
  5. andyzauk

    Trying to count pivot items on screen

    Hi, I am trying to count the amount of items visible on screen for a row field in a pivot table. I am doing this: CategoryAmount = ActiveSheet.PivotTables("YTDTrendPivot").RowFields("Cost Buckets").VisibleItems.Count This, however, shows me the list of items available in the dropdown list for...
See more

Part and Inventory Search

Back
Top