Forum Discussion

MathisFINU's avatar
MathisFINU
Copper Contributor
Nov 24, 2022

Pivot table var not working on daily data

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 : 

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.

 

No RepliesBe the first to reply

Resources