I have sum of amount by date. I want to show this amount in 7 days interval in pivot table. The starting date and number of 7 days(Weekly) will be input(Input box).
The starting date may be any weekday name sun, mon,tue and etc..
There is two inputs. 1. Start Date and 2. Number of weeks (Numeric).
If start date is monday(10/Jun/2013) and Number of weeks = 2, then my result should be,
Asset
Week
Amount
Total
10,424,379.90
AB
10/06/2013 (Mon) - 16/06/2013 (Sun)
5,250,139.17
CD
17/06/2013 (Mon) - 23/06/2013 (Sun)
5,174,240.73
If start date is Wednesday(12/Jun/2013) and Number of weeks = 2, then my result should be,
Asset
Week
Amount
Total
10,424,379.90
AB
12/06/2013 (Wed) - 18/06/2013 (Tue)
5,250,139.17
CD
19/06/2013 (Wed) - 25/06/2013 (Tue)
5,174,240.73
The number of weeks input is upto 54. Is this possible? Please let me know.
