• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table filter by Multiple Checkbox

jsmithjames03

New Member
Hi,

Kindly help me to filter a pivot table by multiple checkboxes.

For the Ex: In a pivot table Month is in the filter. but I want to view the sum of multiple months of data selected by the checkbox.
 

Attachments

  • Pivot Filter By Chkbox.XLSM
    60.4 KB · Views: 3
The attached may not work for your version of Excel (What is it?)
There's a slicer, all code has been removed (not needed).
You can make month selections as you do say in File Explorer;
clicking on one month, holding the Shift key then clicking another will select all months inbetween.
clicking on the 80481will select all months,
clicking on a month while holding the Ctrl key will alternately select/deselect just that month.
 

Attachments

  • Chandoo48611Pivot Filter By Chkbox.xlsx
    31.7 KB · Views: 6
Back
Top