pivot table field

  1. R

    Macro to add field into pivot tables

    Hi all, I am trying to create a macro that will insert the field "Month" into the 'Axis Fields (Categories)' section on all pivot tables in my workbook. I created a dashboard that has slicers for all kinds of stuff. Now i want a button that will break down the view into months, and remove the...
  2. D

    Grouping Pivot Table Fields

    Hi there! I want your help on how to execute this on Pivot Table. What I want is to put the ENG Sum to Row value, and upon clicking it, all the components (ENG_123, ENG_456 and ENG_789) will appear. Then the value for those components will be shown as well. If this is possible, please let me...

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