I have to do a Pivot table with a big number of data (arround 3600 lignes and 46 columns).
With this pivot table i'm comparing the variation of 2 column but when i want to isolate a certain date range the daily data display a #div/0 but the monthly and yearly show the numbers. I don't understand why i can't get the daily.
Here you can see that every thing is fine :
Then when i extend to daily it shows the #div/0 error
Here is the type of data i'm dealing with
If you can give me an answer on how to resolve this issue it would made my day.