This content has been marked as final. Show 2 replies
I am trying to work on a set analysis that counts the number of Employees who had a decreased number in sales from the previous quarter but I am having trouble figuring out how to go about doing this.
So far I have:
but am unable to get past this. I've tried the count function but can't seem to get it to work. Ultimately I would like to be able to drill down from Company>Department>Employee but for right now just need the number of employees that decreased.
The table looks something like this:
Any help would be appreciated, thank you!