My pivot table show drivers and their monthly activity.
When I want to see theirs works on sundays I calculated new fields in pivot table and use formula =if(weekday(date)=7;workhours). Everything is Ok but in total show 0.
how can I see total for each drivers monthly?