Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Pivot Table Format for special case

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
Answers
-
any expert view on this???
0 -
I think you can achieve this by conditional formatting on month column cased on your shop number column.
0 -
Hi Rama,
Thanks problem here to distribute Months between Start Date & End Date.
How to identify how to plot for ever month by checking its start date and end date.
Regards
sher ullah baig
0