Hi

I'm making a running total in pivot view usign zoho analytics with time as a field variable. The problem is, the time coloumn has multiple null values which I want to filter out. However, I can not filter Null values or unknown values from a coloumn on the date format. Now the null values gets a seperate coloumn and are calculated as part of the running total even though I hide the -no value- coloumn.

Hope somebody can help me with my problem.

Thanks in advance