Two products on a Single date, Pivot date grouping through gaps

[Rajendra_kodavaty]

I have the following sample daily production data as below. The three digit code represent a product.

<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;">11-Mar-15   LBA
12-Mar-15   LBB
12-Mar-15   PXA
13-Mar-15   GNA
</code>

When i want to apply pivot i get the above data as below since two products are manufactured on same data

<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; white-space: inherit;">3/11/15 LBA
3/12/15 LBB
        PXA
3/13/15 GNA
</code>

I wanted to show the report based on month and I also understand that pivot will not be able to group the dates by month if there are any gaps in between. How can i bypass this to group dates by Month?

 

[Canapone]

Hi,

what version of Excel is at your disposal? In Excel 2010 or more recent versions you can repeat item and fields labels.


Here some instructions:

https://support.office.com/en-us/article/Repeat-item-labels-in-a-PivotTable-report-882bdb55-9cdc-4d8d-b531-8e96e41dea31

 

[Smitty]

Crossposted: http://www.excelforum.com/excel-char...ough-gaps.html

It's not a big deal, but we ask that you point it out so you don't have people in multiple places doing the same thing for you.

Please see: Excelguru Help Site - A message to forum cross posters

 

[Rajendra_kodavaty]

My question was not to repeat the column labels but to group them as per the month. For example i have the following daily production report

3/11/15 ABC
3/12/15 GHI
3/16/15 DHI
7/20/15 YHU
7/20/15 FGI
7/21/15 FGI

When i convert it to pivot i get the same after checking repeat item labels but without checking the box you would find gap in last but one row under date.
I want the desired format to be displayed in months rather than dates as below

Mar-15 ABC
Mar-15 GHI
Mar-15 DHI
Jul-15 YHU
Jul-15 FGI

Now i have come to know that of there are any gaps the excel will not be able to group the dates in to months. How can i get over it to achieve the desired result?

 

[Rajendra_kodavaty]

Smitty, But i have posted the link of the post in other forum, which was allowed as per rules. How do you want suggest me to do otherwise