Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
Header 1 | Header 2 | Header 3 |
---|---|---|
resourcetype | empid | silo |
ss | 100 | silo1 |
ss | 200 | silo1 |
ss | 300 | silo1 |
tm | 400 | silo1 |
tm | 500 | silo1 |
dm | 600 | silo1 |
dm | 700 | silo1 |
dm | 800 | silo1 |
dm | 900 | silo1 |
ym | 1000 | silo1 |
ym | 1100 | silo1 |
I have to show Number of employees by Silo only for the Resource_Types 'ss' and 'tm'.
and i should have a filter to filter only by 'SS' and 'tm'.
and By default it should show me 5 Employees whichc are related to Resource_Type ss and tm only.
Than if i select SS ,it should show me 3 as count and if tm ,then count should be 2.
Regards,
Pratik
Maybe this will work:
If(GetSelectedCount(resourcetype) = 0, Count({<resourcetype = {'ss', 'tm'}>} empid), Count(empid)
this will show count if you select ym or dm, is that going to be a problem?
Best,
Sunny
Maybe this will work:
If(GetSelectedCount(resourcetype) = 0, Count({<resourcetype = {'ss', 'tm'}>} empid), Count(empid)
this will show count if you select ym or dm, is that going to be a problem?
Best,
Sunny
Hi Pratik,
please see the attached example, hope it helps
andy
Much more elegant way to do it.