This is done in the usual manner. I don't know how to do this or where to write Q1, Q2, etc. And we create a simple pivot from this data set. By using this row field here rather than a column field, you can avoid the annoying popup messages about adding items to the pivot table. ... After you create a pivot table with the date field, the date format is fixed. The Calc column depicts the type of calculation and there is a Serial number for each. Name Jan Feb Mar Apr Bob 12 10 4 3 5 James 2 6 8 1 15 etc. Tip - if you are looking at Actuals data and are interested in day level granularity, then some reports have a row field called Work Date. Drag the new field to the Values … It allows you to quickly summarize a large chunk of organized data. I need the Invoice Date to display as 1/1/16 like it did in previous versions of Excel. Add the RegNum field to the Values area, and right-click on one of the numbers. Probably the fastest way to get it back is to use the right-click menu. You'll notice that only some of the rows show 1, meaning the formula result is TRUE. Next to Pivot Table I have created a small table with the following data. Quick Note: You can use above steps to create a group of dates for any number of days and please note that week created by pivot table is not on the basis of Mon-Sun. Drag Rep to the Rows and Version to Columns. You can also decide on how you want to display your values. Pivot Tables dates weren’t grouped in earlier versions of Excel, but that behaviour changed in Excel 2016. To quickly display or hide the current subtotal, right-click the item of the field, and then select or clear the check box next to Subtotal "