Hi, the data is shown below
| Products | Cost | Start date | End date |
| Desktop | $300 | 14-Jan-15 | 14-Feb-15 |
| Voip | $50 | 15-Jan-15 | 15-Feb-15 |
| Mouse | $20 | 16-Jan-15 | 16-Feb-15 |
| Desktop | $200 | 17-Jan-15 | 17-Feb-15 |
| Desktop | $200 | 18-Jan-15 | 18-Feb-15 |
| Desktop | $200 | 19-Jan-15 | 19-Feb-15 |
| Voip | $50 | 20-Jan-15 | 20-Feb-15 |
| Voip | $50 | 21-Jan-15 | 21-Feb-15 |
I need help on this.
I want to create start date and end date as calendar.
and according to that my pivot table needs to fetch the above data and at the same time i want to calculate the sum of cost of similar product.
for example :L the desktop between those dates , it has to sum up and give me the result in pivot table.
please help me out.
Srujana
.png "Luminary Alumni"){kind=icon}
