Hi,
We have special scenario. We are storing Shop number ,Start Date and End Date.
we received requirement from user to represent Shop number based on its Start date and End Data month by month in Pivot table. Example if Shop A-04 Start Date is 1 may 2014 and End date is 31 Jul 2014 then we have to fill Pivot table Cells for Month of May, Jun and July and rest cells blank. Please share your expert view on this. Thanks
Current Data:
| shop | Start Date | End Date |
|---|
| A-04 | 5/1/2014 | 7/31/2014 |
| GF-10 | 5/1/2014 | 10/31/2014 |
| FF-A04 | 5/1/2014 | 9/31/2014 |
Required As:
Regards
