Hi,
I have been trying to include missing numbers in a pivot chart (Nil Data). For example I am trying to show Week Numbers for a whole year over multiple years but where I have 2014 shown buy itself there is data in Week 1,2,4,5,7. etc. I would like to show the missing weeks 3,6 and so on with a value of Nil..................Is this possible.