Exclude value from columns in Pivot Table

[yazanwael]

Hi Everyone...

I've been trying to do something with pivot tables but I can't figure it out at all...
I want to add a calculation (value) in my pivot table outside the columns.
So for example, I want to make some calculation, and then show another calculation split by columns.
Not sure if my requirement is clear or not, but this simple example will make it easier to explain. I'd like to get the summary table (below) using Pivot Tables (if possible).

In this example, I would like to calculate the average age for the entire population (regardless of marital status), but calculate the average years of service based on marital status. Is it possible to do that in a pivot table ?

Thanks in advanced

 

[jasonb75]

It would not be possible in a single table, the only way that you would get it close would be to have 2 pivots side by side then hide the column with the row labels on the second one.

The downside to that would be potential for misaligned data if you attempt to sort or filter anything as they would be independent of each other.