pivotfilter

  1. H

    "+"-sign infront of Pivot filter when using data from the "data model"

    Hi, is there a way to get rid of the annoying "+" sign inform of the filter topics? When using data from Excel sheet they are not visible but when adding data to "Data model" they are all the time visible. Please see screentshot below In the example to the left the data is from the excel sheet...
  2. A

    Filter Inside Pivot table data values

    Hello, @MARK858 - Is it possible for you to help me on this please. I have a Pivot table, where i need to Select Blank Column next to last row of Pivot table and Put Filter. I tried some coding but i am getting an error. Please help to rectify. Steps: 1. select Row from a Blank Column (Here it...
  3. E

    Problems to filter a pivot table with a date

    Hello Guys! I've been searching a lot looking for a solution to my problem and seems like this problem has been solved a lot out there, but those solutions doesn't apply to my case or i'm surely missing something. I'm making a dashboard that refreshes everything on it, depending on a date...
  4. A

    Linking PivotTable filter to a cell

    Hello, thanks a lot for this forum, I have found a lot of answers on this one. However, now I am so stuck with one question as what I've found so far does not work, and I really need your help. I have a PivotTable2, the filter of which I want to link to a cell value (C1). The cell value itself...
  5. B

    Pivotfilter on date- problem formatting field or named range used as criteria

    I am guessing this may be a date formatting 101 question... I have a pivot table based upon data that was brought into the spreadsheet from another system. There is a date field (Date Opened)- values come in with a timestamp. on pivot table, I manually group that date field and can filter...

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