Pivot Table - How to group by filter value?

[Motestfilter]

Hi,

I am kinda new to excel and I have this pivot table that has 2 filter values. I need the rows to show both filter value but it should be grouped by value or at least if I could sort them depending on their filter and add a blank row in between so I could label which is which depending from their filter. I have tried searching how can I do this on google and on here and I am not seeing any concrete answer or I could be also not using the correct search words. Thanks in advance.

 

[sandy666]

post a link to the shared excel file with your example and expected result

 

[Motestfilter]

https://imgur.com/a/cMuPA97

Hi. Thanks for the reply. Please check link above. I am not able to upload any file due to restrictions.sorry

 

[sandy666]

use OneDrive, GoogleDrive, DropBox or any similar and post a link to the shared excel file

 

[SpillerBD]

Have the value fields in the Row area and apply the filter there. You may like using the Slicer Options to have a Filter selection outside the filter.
In the Field options, you can have a blank line between values.
In the Design Ribbon for Pivot Tables, select the Report Layout to Tabular

 

[Motestfilter]

https://www.dropbox.com/s/gpm467eiwppgcqz/Book1.xlsx?dl=0 this would be the test file. Thanks

 

[Motestfilter]

Have the value fields in the Row area and apply the filter there. You may like using the Slicer Options to have a Filter selection outside the filter.
In the Field options, you can have a blank line between values.
In the Design Ribbon for Pivot Tables, select the Report Layout to Tabular

Thanks for this! This is what I wanted. The issue now would be the field that was moved from filter to rows causing the main filter to disappear. Checking your advise about the slicer and figuring out how it works. Thanks again

 

[SpillerBD]

Slicers are filters. The slicer is its own object and can be formatted for size and layout (number of items wide). Also a slicer can be linked to multiple Pivot Tables.
The Filter Area cannot share any fields with Rows or Columns, so deciding the best mix may be difficult. Sometimes I resort to duplicating a field to get my desired results despite the agony it causes data-OCD.

I think Mike Girvin has a good video on Slicers. See ExcelIsFun channel on YouTube.