Show Start/End Dates as Separate Columns in Pivot

[malorri]

Hi. I have a simple data set (project activities). I would like to be able to pivot and show three layers of information with start and end date as separate columns. See the attached spreadsheet as an example. How can I display start and end dates affiliated with the activity (columns A, B, C)? The pivot function wants to calculate--I just want to display the dates without having to cut/paste. Suggestions?

[alansidman]

I have created what you are looking for by placing all items in the Rows. See attached.

[malorri]

Thanks. That gives me the desired outcome. I am not seeing how you came to that result. I have placed all items in the rows in a pivot and they appear as one column with each level indented. What additional steps did you add? It looks like you grouped related tables. I am not seeing how you did that though.

[alansidman]

Open the Design Tab, Select Report Layout. Select Tabular.

[malorri]

That worked! Thanks.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.