If you can provide VBA code or share how it would be possible via the Pivot table, that would be awesome.
I also tried to right-click on the Pivot table containing the First Name and clicked on Filter, then Value Filters and sent the filter to Sum of Amount i s greater than and type 5000 but it also shows if the grand total of the individual is greater than $5000 for all years instead of isolating for the subtotal of each year and checking that. I am not sure how to attached the excel file with the pivot table but I pasted the table below. Column subtotals always appear at the bottom of the group. Notes: Column fields are not affected by the setting for Subtotals. In the Layout group, click Subtotals, and then click Show All Subtotals at Bottom of Group. Please see the picture below for a visual example. Select a cell in the pivot table, and on the Ribbon, click the Design tab.
I did conditional formatting to identify such individuals (highlights subtotals in red) but the pivot table would not let me isolate them to show only the individuals with subtotals exceeding $5000 per year. Sub TurnOffPTSubs() Dim lX As Long If > 0 Then For lX 1 To ActiveSheet.PivotTables(1).RowFields.Count If ActiveSheet.PivotTables(1).RowFields(lX).Name <> 'Data' Then ActiveSheet.PivotTables(1).RowFields(lX).Subtotals Array( False, False, False, False, False, False, False, False, False, False, False, False) End If Next For lX 1 To ActiveSheet.PivotTables(1).ColumnFields.Count ActiveSheet.PivotTables(1).ColumnFields(lX).Subtotals Array( False, False.I was wondering in a Pivot Table, how can I filter/use a slicer to display all individuals who have a subtotal over $5000 per year.
0 kommentar(er)
