pivottable multiple items

  1. Data Bender

    Double-Click PivotTable Item without Displaying Excess Records

    Thank you for reviewing my post. When double-clicking a PivotTable value, how does one limit the records displayed? For example, it makes intuitive sense to see only one record, when double-clicking the value of 1 in the following PivotTable: However, I get the following nine records...
    • Data Bender
    • Thread
    • double click multiple records pivottable pivottable multiple items
    • Replies: 6
    • Forum: Excel Questions
  2. K

    Total multiple cells but ignore any of them that may return errors

    Hi, I'm new to this place as a user, but always reading up on other threads. I've got a cell I'm trying to use to total multiple cells (maybe 30?) from a pivot-table together. They are not a range so I don't believe a sum function will work. However sometimes, depending on the data being used...
  3. B

    VBA to Select Multiple Items in Pivot Table

    Hi, I'm trying to write a macro to select the multiple sets of the same data for several PIVOT tables. I've tried Slicers but it seems that this takes up too much processing power and always times out. My workaround is to do a macro that picks out the said data, however when i do the below...
    • Bench
    • Thread
    • pivottable pivottable multiple items vba
    • Replies: 4
    • Forum: Excel Questions

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