pivot table blanks

  1. P

    URGENT: Pivot table from set with repeat data, blank cells

    Attached is a sample of the data set I am working with. I am trying to figure out how to create a pivot table so I can easily filter and see numbers like: -How many dogs vs cats were adopted -Who adopted the most number pets -Which city had most number of pets up for adoption -Of those, how...
  2. E

    Hide completely blank value rows in a pivot table

    I have a pivot table that is showing two values. However, some rows have zero for both values, some rows have both values, and some rows just have one of the values. If I use a filter for one of the value columns is hides the row irrespective of a value in the other column. I need some way to...
  3. L

    Empty values in Pivot table?

    I have a series of accounts and period balances coming from a database. Each line is basically: Year - Month - Account - Netchange I'm using Pivot tables to summarize this information for YTD calcs. I put "NETCHANGE" into the values of the PivotTable and set the name to YTD and the Set the...
  4. S

    PivotTable Show Value As (% Difference From) Problem

    I have a data set that looks smth like this: <STYLE type=text/css> table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;} .tableizer-table th {background-color...
  5. L

    help With Pivot tables

    Hi, I have a Spreadsheet and within it there is a column with dates and some cells are blank. when i make a pivot table with this spreadsheet, the blank cells show up with "(blank)" in them. Can I tell it not to put the "(blank)" in the cells and just actually be a blank cell? Sincerely, Lauretta
  6. V

    Pivot Tables and multiple column criteria counts

    Hi Everyone, I need some help. I am using Excel 2007 (and excel 2003), and I have a pivot table that looks like what I have below. What I am trying to achieve is get a count of all the accounts for each rep and then a count of each account that has a total. <?xml:namespace prefix = o ns =...
  7. A

    Pivot table unable to group dates

    If I choose the source data for my pivot table as colums (providing for continous updating) I cannot group my dates per year/month. Because Excel says I have zero empty rows for date (all rows do contain dates, so zero are left blank) If I select the exact cells containing the data I can...

Some videos you may like

This Week's Hot Topics