Excel pivot table: display rows filtered, but keep total for all rows (unfiltered)

Question

I have a pivot table where I filter the data by month. The thing is I need a total column for all months. Is it possible to somehow ignore a select column from being filtered? Or maybe there is a way to achieve it using calculated fields.

Example:

October  500 clicks
November 600 clicks
December 1000 clicks

I use filter: November

I get a table:

google | 600

What I want to get after using this filter:

google | 600 | 2100

Answer 1

It is not possible directly. As the closest workaround I am aware of you may use the following:

1. Add a calculated column to your source data, calculating the sum of all the respective values

Explanation of the formula =SUMIFS($C$2:$C$9,$A$2:$A$9,A2):

Sum all the values from the C column, where the respective value in the A column matches the value in the A2 cell. So it is effectively equivalent with

= C2 + C4 + C6 + C8

2. Create the pivot table with an extra field Total, displayed as Max (or Min, it doesn't matter as it always contains the same value):

3. Without filtering it contains all the months:

4. Now you may filter your months: