having problem with dates in pivot table

[rakesh seebaruth]

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

 

[mole999]

don't know if this would work. On your data page you might set all your future dates and then have a workbook macro unhide rows a day at a time, your data then should reveal daily levels set by you, you'll need a refresh in there

 

[rakesh seebaruth]

thanks

let's say for example i have selected a date range from 1/1/2017 to 12/1/2017. I have created my pivot table. It works fine. Here is my problem. on 13/1/2017 my date and data for that particular will now appear in pivot table. If i want to make the date and data for 13/1/2017 appear in the pivot table i will have to select date range 1/1/2017 to 13/1/2017 to make 13/1/2017 appear in the pivot table.Each time i have to do that for any next date. Can you help on this please.i want to do it auntomatically as soon as i insert the date and data pivot table updates it automatically

Thanks

 

[mole999]

did you try setting your data range to greater than now?

hiding the rows you don't want then refreshing the pivot

I understood what you wanted the first time, just not 100% sure that works, and I'm not creating a set up I don't need

 

[mole999]

just tried it and my thought didn't work, thought it might act like a chart