Combining Pivot Tables into one table

[quilldew]

Hi,

Now you're probably thinking I should have used the search function. I did, but unfortunately can't find my exact problem with a solution, so here goes

If I have a table like so:

Name	Colour	Job	City	Date
1	G	Driver	London	01/01/2016
2	R	Walker	Paris	02/01/2016
3	B	Swimmer	Paris	01/05/2016
4	R	Swimmer	NY	03/06/2016
5	G	Driver	Dakar	17/06/2016
6	B	Sleeper	Timbuktu	02/12/2017

I can create Pivot tables that look like:

I would like to be able to combine those tables so that the caption and Date line don't appear on the second table and the City lines appear directly below the Name lines, like an Excel KPI based on 'Date' would look like. ie:

Many Thanks

[sunny_talwar]

Like this?

[quilldew]

Hi Sunny,

That is very very useful thank you, but is there a way to keep the name of the dimension inbetween the rows, and also a way to show the subtotals of each date?

[sunny_talwar · Accepted solution]

How about something like this?

Or this

[quilldew]

Perfect, many many thanks. Now researching the 'pick' function