ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   PivotTable - Filter Row (https://www.excelbanter.com/excel-discussion-misc-queries/449334-pivottable-filter-row.html)

Peter[_69_]

PivotTable - Filter Row
 
I am working on creating a pivot table for the data I have. The data looks something like below:

ID Policy_July Policy_June Policy_May Policy_April Policy_March Label

13 High Med High High High Good
2 Low Low Low Low Low Good
3 Low Low Low Low Low Good
4 High Med High High High Good
5 High Low High High High Good
6 Low Low Low Low Low Bad
7 High Med High High High Bad
8 High Low High High High Bad


I am comparing results from July with other months. Is there a way I can add a filter for row to enable me to change "Policy_June" to "Policy_March"? Basically, instead of having a filter for column, can I have filter for row in pivot table? If so, can you please guide me on how can I do it?

Again, what I am looking for is to have a filter button above the pivot table that would enable me to change "Policy_June" to "Policy_April".

Secondly, is there a way I can have "Grand Total" as a column (like I have at the bottom of pivot table)? I am trying to sum the value of "Bad" and "Good" for "High" and show the result in the column in yellow.

I am looking for something like below:

Filter Box to select Column Label

Policy_July Policy_June (Column Label)
(Row Label) High Med Low
High 5 3 2

Med

Low 3

Let me know if you need any additional clarification.

Thanks for your time and guidance.











All times are GMT +1. The time now is 12:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com