pivot table data

  1. J

    Table Columns based on Pivot Table Data

    I have a table that shows sales for a date range. I'm running a query to pull invoices and dates and then using vlookups to pull in data from another worksheet. The system that I'm running the query on has custom payment methods available. I need to only show the payment methods that exist in...
  2. K

    Get pivot table data showing total of previously billed on statements

    Hello MrExcel members, I have a billing statement I'm working on, which is populated mainly from a pivot table. The columns I am struggling with are labeled "Previously Billed", "Total Earned", and "Quantity To-Date". The pivot table includes all twelve months as headers, and the billing...
  3. M

    How to show the labels of all rows of a Pivot Table?

    I am creating a spreadsheet that summarizes a deeply nested set of folders in a SharePoint Library. The information I have for every file includes Site, Library, F1, F2, F3, F4, F5, F6, F7. Basically I have an excel file that specifies for each file the site, library and the names of the sub...
  4. C

    Pivot Table: Can't update data

    I've built a fairly elaborate set of pivot tables based on data in one worksheet. Then, I have a "report page" which is a sheet with a pull-down to select one variable and then the sheet is populated with data from the different pivot tables. This is to produce a monthly report. I have a new...
  5. P

    Pivot data

    Hi All, I have an time sheet with following no of hrs logged for all resources . Name 2011/01/01 2011/01/02 Prash 10 10 Prakash 12 15 I need the above data as below. Name Date Hrs Prash 2011/01/01...

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
Back
Top