pivot calculated sort

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

    Pivot Tabkle query

    I have a simple database of food makers. Three fields: maker name. Food category, Region. I have about 1200 records. I have created a pivot table with category and region on X and Y,and it shows a count of makers in each cell.Which is fine as far as it goes. But I want to list the names of the...
  3. P

    Help with a complicated problem in calculating data inside Pivot Tables!

    Hi, I am building an excel database with a lot of data that I will be updating daily. I need to generate charts from it as I update, so I am using pivot tables and charts. I also need the pivot table to organize the data properly. The problem I am facing is that once the data is organized in...
  4. S

    Cumulative percentage in Pivot table (Pareto?)

    Hi, I am recording the downtime of machines and putting into order of most - least downtime for each of the reasons recorded against the machine being monitored. This works fine when sorting the ivot table by the total downtime column. I have been asked if I can add a cumulative percentage...
  5. J

    Sorting Hi to Low

    Hi, I apologize in advance if this question has been answered, I've looked and cant' find the answer. I am new to Pivot Tables, but have figured out how to create the database and the resulting Pivot Table. My Sales Database includes the Sales $ and GP$ for each line. In the Pivot Table I've...

Watch MrExcel Video

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