Pivot Table Row Labels for date values

Question

I need my row labels to be the actual value in the field, which happens to be a date field.  So, I have several records of the same date (date format) and when I create the Pivot Table, the row label is formatted with tree/expandable options showing the year, Qtr, month.  I just simply want to use the date value instead of the expandable options.  what pivot table setting do I modify to do this?

thank you

Answer 1

Hi,

We would like to follow up on the challenges that you are having when creating a Pivot table in MS Excel. It is true that there may be settings that you need to check in order to create the right table. We would like to ask, were you able to check this **link**on how to modify the data and values that are showing in your table? The link should give you a more detailed information on how you can create tables in MS Excel.

Should you have any other concerns, don’t hesitate to let us know.