Pivot table var not working on daily data

New Contributor

Hi, 

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 

b20a5a88-8f86-4d03-8a6f-92e80f72c555.png

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