Displaying department results for certain employees

[aljaztoman]

Hello,

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!

[Kushal_Chawda]

Would you need script solution or front end?

[Kushal_Chawda · Accepted solution]

on frond end, create a straight table

Dimension:

Employee

Dept

Expression:

=if((sum(A)+Sum(B))=0,
sum(total <Dept> aggr(sum(A)+Sum(B),Dept)),sum(A)+Sum(B))