Forum Discussion
MathisFINU
Nov 24, 2022Copper Contributor
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