blank dates should be automatically filled up and value is zero in pivot table

[learning_grexcel]

I use pivot table in excel to generate output something like below :

date >> sale >> purchase
01.03.2011 >> 25 >> 35
02.03.2011 >> 35 >> 15
05.03.2011 >> 17 >> 32

As you can see there is no data for 3rd and 4th so it omits it But I want them in output and value should be automatically blank or zero
like this
01.03.2011 >> 25 >> 35
02.03.2011 >> 35 >> 15
03.03.2011 >> 0 >> 0
04.03.2011 >> 0 >> 0
05.03.2011 >> 17 >> 32

 

[Gerald Higgins]

Can you add those dates as dummy data entries ?

To make it easier, and avoid having to identify the empty dates, you could try just adding every date for your entire period.

 

[learning_grexcel]

Can you add those dates as dummy data entries ?

To make it easier, and avoid having to identify the empty dates, you could try just adding every date for your entire period.

No, it's not possible. I cannot add dummy date entries as it has lots of data.