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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top