pivot table sorting

  1. C

    Pivot table sorting

    I would like to sort a column in a pivot table by "A". The column is called memo currently holds values called A,B,C and n/a but I will not always know what the values will be in the future. I need something like .PivotItems("All").Visible = false .PivotItems("A").Visible = true Thanks for the...
  2. C

    Pivot table sorting

    I want to sort by a specific pivot table column, ultimately to copy and past the copied column into a new worksheet. This needs to happen for memo line A B and C. The column is called "Memo" and contains memo line A,B,C and N/A. Problem: I want to deselect all pivot table items then make the...
  3. M

    Multiple sorts in pivot table

    On a regular excel spreadsheet, we can tell when multiple columns have been sorted in a certain order. For example, let's say one column contains labels and another contains amounts. In this case, we can sort by amount descending and then label ascending to see biggest to smallest within each...
  4. D

    Pivot Table sorting with Multiple Columns of Numbers

    I have been trying to find a way to sort my PV table by the number of Accounts each sales person has sold from Largest to smallest. The problem I have been running into is there is more then one column with numbers. The territory for example is also labeled by number. Example territory 1-50...
  5. K

    Pivot Table Sort not following my orders!

    First Post - Hope I do this right....:) Currently we are using Dynamic Great Plains for our MRP system. I'm trying to make a report that shows a bunch of information and i'm having a very hard time sorting the data so i will try and list everything I have so far. We have a view that was...
  6. K

    VBA sort in pivot table; clueless.

    Hi all, I use Excel 2003. I have a pivot table to make a pivot graph. It's a graph about the percentage of production per employee that was faultless. The pivot table looks something like this: <TABLE style="WIDTH: 268pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=357...
  7. C

    Sorting in a pivot table

    I've built a pivot table, and put a field in the 'Drop Page Fields Here' box. However, (using State abbr) the states are appearing in what looks like a random order. How can I sort this alphabetically? Thanks, Clint

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top