Rajendra_kodavaty
New Member
- Joined
- Oct 12, 2015
- Messages
- 23
I have the following sample daily production data as below. The three digit code represent a product.
When i want to apply pivot i get the above data as below since two products are manufactured on same data
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?
Code:
<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>
Code:
<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>