Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a problem with the summing in the pivot table. For example i have one column in the table and it showing total as 3,51. When i change it to sum----option where you can choose which function will you use...it is correct(with sum function). In the pivot table it just showing 3,51 and i want to have the number from the column 2(in Screenshot).
Move your if() statement inside the sum, rather than vice versa.
not working...this is my formula...
if(status<>'COMPLETED' OR status<>'DEFERRED', sum(distinct(Zeitaufwand_Grouped/Stunden_Grouped))/count(distinct Mitarbeiter_ID))