When you place the Date field in a row field area, you can display the date in multiple columns, and when you place it in a column field area, you can display the date in multiple rows.

Normal display (date is displayed in single row)

Display the date in 3 rows, "Month", "Day", and "Weekday"

Below are the steps to display date in multiple levels.

1. Click the Settings tab on the App settings page, and click the krewSheet settings gear icon from Plug-ins to open the krewSheet settings page.
2. Select the Date field and click Settings on the Home tab of the ribbon area. Also, you can click the gear icon of the Date field.
   
3. The following dialog box is displayed.
   Click Display Date in Multiple Levels option and select "Year", "Quarter", "Month", "Week", "Weekday", and "Day" to be displayed.
   

When you place the Time field in a row field area, you can display the time in two columns, and when you place it in a column field area, you can display the time in two rows.

Normal display (time is displayed in single row)

Display the time in 2 rows, "Hour" and "Minute"

Below are the steps to display time in multiple levels.

1. Click the Settings tab on the App settings page, and click the krewSheet settings gear icon from Plug-ins to open the krewSheet settings page.
2. Select the Time field and click Settings on the Home tab of the ribbon area. Also, you can click the gear icon of the Time field.
   
3. The following dialog box is displayed.
   Click the Display Time in Multiple Levels option.
   

The date subfields are displayed by expanding the Date field.

The subfields of Date is a unique field that carry off only the "Year", "Month", and "Day" parts from the date, and can be aggregated in groups such as "Year" and "Month". Multiple level display of dates is a feature that only changes the display method of dates.

Also, the "Date" in the date subfield is independent of the original date, and it does not have information related to the year or month.

Setting Example

0. Source Data

1. Create a pivot table by setting "Date (Year-Month-Day)" in column field area

2. Display date of 1 pivot table in multiple levels (only "Month" and "Day" are displayed)

There is no change in the aggregation, only the display of the header portion changes ("January 1, 2021" and "January 1, 2022" are aggregated separately).

3. Use the "Month" and "Day" subfields

It will aggregate items with the same month and day (for example, January 1, 2021 and January 1, 2022, with different years, are aggregated in the same aggregation group). Since we are using two fields, Month and Day, the subtotal for each month is displayed.

4. Use the "Year-Month" subfield

It will aggregate items with the same year and month. Unlike 3, we are using only one field (Year-Month), so the subtotal is not displayed.