Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am having a problem with a straight table measures. I am trying to show the hours taken for each employee in period time number 2 (p2 column), and i have a set analysis there.
From some reason, only when I click on specific employee it shows the right number. It represent a wrong number generally when I don't choose a employee.
So it has a filter problem that I don't understand yet.
Please help me find it out.
wrong number - when employee is not filtered yet
right number - after employee is filtered
the set analysis is like this:
num(sum( {$<
*Some filters*,
Period={'P2'}
>}[Reported Hours]),'##0')
Thanks
Thanks