Pivot Table - How to insert the value of cell instead of Count?

[Kathy1177]

I have a complex Pivot Table. I have 20 publications listed in rows on the left, and the Date the pub passed a certain review stage. Dates of review are indented in rows under the pub name. In the table, I want the output to list the dates sequentially across the single row for that pub, under the column header for the reviewer's name. Instead of the date across the row, I get the number "1" because the Pivot Table counts each occurrence of a view stage, then sums the number of reviews on the right and at the bottom. Ideally I want the dates in the table, but a count in the final column on the right and the final count of totals in each stage at the bottom. Any way to do this? This is way beyond my current Pivot Table skills.

Currently, my Pivot Table looks like this:

Publication Reviewer1 Reviewer2 Reviewer3 Total Reviewed
------------------------------------------------------------------------------------------------
Medical Cures
5/1/14 1 1
7/3/14 1 1
4/2/15 1 1

Technical Successes
2/11/15 1 1
3/12/15 1 1
6/1/15 1 1

Total in Each Stage 2 2 2 6
--------------------------------------------------------------------
--------------------------------------------------------------------
I want it to look like this:
Publication Reviewer1 Reviewer2 Reviewer3 Total Reviewed
-----------------------------------------------------------------------------------------------
Medical Cures 5/1/14 7/3/14 4/2/15 3
Technical Successes 1/8/15 3/2/15 6/1/15 3

Totals in Each Stage 2 2 2 6

 

[scottsen]

It is not clear from your message if you are using "Power Pivot" and the DAX language and such? (And if not, I dunno... somebody here might, but the "main" forum is a better place for the Q)