rakesh seebaruth
Active Member
- Joined
- Oct 6, 2011
- Messages
- 303
hi there
i have the following table
[TABLE="width: 268"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD] [TABLE="width: 268"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]date [/TD]
[TD]items[/TD]
[TD]sold[/TD]
[/TR]
[TR]
[TD]17/1/2017[/TD]
[TD]orange[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]18/1/2017[/TD]
[TD]pineapple[/TD]
[TD]42[/TD]
[/TR]
[TR]
[TD]19/1/2017[/TD]
[TD]strawberry[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]20/1/2017[/TD]
[TD]pears[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]21/1/2017[/TD]
[TD]apple[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]22/1/2017[/TD]
[TD]berries[/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]23/1/2017[/TD]
[TD]mangoes[/TD]
[TD]65[/TD]
[/TR]
[TR]
[TD]24/1/2017[/TD]
[TD]litchis[/TD]
[TD]70
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
25/1/2017 bananas 90
26/1/2017 tomatoes 25
27/1/2017 watermelon 40
28/1/2017 ananas 60
I have been able to create a pivot table with the above data including slicers from 17/1/2017 to 28/1/2017. My last date is 28/1/2017 . How to include tomorrow's date (29/1/2017) and future dates in my pivot table . How to do it automatically.
Thanks
Regards
rakesh
i have the following table
[TABLE="width: 268"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD] [TABLE="width: 268"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]date [/TD]
[TD]items[/TD]
[TD]sold[/TD]
[/TR]
[TR]
[TD]17/1/2017[/TD]
[TD]orange[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]18/1/2017[/TD]
[TD]pineapple[/TD]
[TD]42[/TD]
[/TR]
[TR]
[TD]19/1/2017[/TD]
[TD]strawberry[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]20/1/2017[/TD]
[TD]pears[/TD]
[TD]60[/TD]
[/TR]
[TR]
[TD]21/1/2017[/TD]
[TD]apple[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD]22/1/2017[/TD]
[TD]berries[/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]23/1/2017[/TD]
[TD]mangoes[/TD]
[TD]65[/TD]
[/TR]
[TR]
[TD]24/1/2017[/TD]
[TD]litchis[/TD]
[TD]70
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
25/1/2017 bananas 90
26/1/2017 tomatoes 25
27/1/2017 watermelon 40
28/1/2017 ananas 60
I have been able to create a pivot table with the above data including slicers from 17/1/2017 to 28/1/2017. My last date is 28/1/2017 . How to include tomorrow's date (29/1/2017) and future dates in my pivot table . How to do it automatically.
Thanks
Regards
rakesh