employee count for active

[vikasmahajan]

Dear All

I have employee master with active and in-active flag  how to show only active employee's in straight table

Thanks in Advance

Vikas

[m_woolf]

You can use set analysis in the expression, something like this:

sum({<Flag = {'A'}>}Amt)

You can also use a calculated dimension:

=if(Flag = 'A',Employee)

[#3 · Accepted solution]

Hi,

Hope it will work

RawData:LOAD * INLINE [
Employee,Flag
v1, Active
v2, IN-Active
v3, Active
v4, IN-Active
v5, Active

];

In Straight Table Take Dimension Employee , Flag

Expression = Sum({<Flag={'Active'}>}1)

Then Hide Expression in Presentation Tab