Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
To whom it may concern:
I followed the previous thread with one dimension and it did not work for me. Therefore, I'm writing for assistance in this formula.
Any assistance is appreciated in advance.
Thanks,
Derek
May be try one of these
Count(CSN)/Aggr(NODISTINCT Count(CSN), DepartmentName)
or
Count(CSN)/Count(TOTAL <DepartmentName> CSN)
May be try one of these
Count(CSN)/Aggr(NODISTINCT Count(CSN), DepartmentName)
or
Count(CSN)/Count(TOTAL <DepartmentName> CSN)
Both work perfectly.
I'm most grateful for the time and effort spent.
This is Solved.
Thanks,
Derek