Add single columns to the value box in a pivot table

[baseline9]

Hi - I was hoping someone can help me

I'm creating a pivot table with the date for the row and a status in the column giving a number of stages (denoted by stage field below )
I would like to include the first two columns in my data to the values box.
One is a sum of unique values (Eg 1 or 0)
The other is count of total. I would like the count of total for the whole data and sometimes this may add up to more than the total for the status's, this is because I'm filtering on another field and I want to highlight the discrepancy (Eg there could be some statuses I'm not including under that filter)

Its basically two pivot tables joined together (first two columns and the stage columns side by side) but I was wondering if I can get it into one? I have tried to display what I mean below.

Hope you can help!
Many thanks!

I'm using v 2013



[TABLE="width: 957"]
<tbody>[TR]
[TD][/TD]
[TD]Unique (1 or 0)
[/TD]
[TD]All 1s
[/TD]
[TD="colspan: 10"]Stage Field
[/TD]
[/TR]
[TR]
[TD]Date
[/TD]
[TD]Sum of unique values
[/TD]
[TD]Total / Count
[/TD]
[TD]Status 1
[/TD]
[TD]Status 2
[/TD]
[TD]Status 3
[/TD]
[TD]Status 4
[/TD]
[TD]Status 5
[/TD]
[TD]Status 6
[/TD]
[TD]Status 7
[/TD]
[TD]Status 8
[/TD]
[TD]Status 9
[/TD]
[TD]Status 10
[/TD]
[/TR]
[TR]
[TD]01/02/2016
[/TD]
[TD]5
[/TD]
[TD]8
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]02/02/2016
[/TD]
[TD]5
[/TD]
[TD]8
[/TD]
[TD][/TD]
[TD][/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]03/02/2016
[/TD]
[TD]5
[/TD]
[TD]15
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]04/02/2016
[/TD]
[TD]5
[/TD]
[TD]9
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05/02/2016
[/TD]
[TD]5
[/TD]
[TD]7
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[SpillerBD]

A sample of your source data would be helpful.
No I don't think there is a straightforward method, but I believe there may some tricks that might achieve your goal.

 

[baseline9]

A sample of your source data would be helpful.
No I don't think there is a straightforward method, but I believe there may some tricks that might achieve your goal.

Hi Thanks for looking at this. I have a sample file how to I get it to you / upload it? I dont have a website to hoast?

Applogies

 

[baseline9]

Hi - I have found a solution by creating another pivot table and linkinng with slicers

Thank you again for offering to help

Many thanks!