Pivot table var not working on daily data

New Contributor


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 : cc75a5e9-af72-4265-aaa2-c1080c291b81.png

Then when i extend to daily it shows the #div/0 error 


Here is the type of data i'm dealing with

screen data.PNG

 If you can give me an answer on how to resolve this issue it would made my day.


0 Replies