I am trying to display department results only for certain employees. Please see below simplified case.
For employee Jarvis (or those, who do not have A and B values), i wish to display those sums, grouped by his DEPT.
How can I do this with set analysis?
Thank you in advance!
on frond end, create a straight table
=if((sum(A)+Sum(B))=0,sum(total <Dept> aggr(sum(A)+Sum(B),Dept)),sum(A)+Sum(B))
View solution in original post
Would you need script solution or front end?