Filtering of Data through Set Analysis.

[#1]

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

[sunny_talwar · Accepted solution]

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

[awhitfield]

Hi Pratik,

please see the attached example, hope it helps

andy

[sunny_talwar]

Much more elegant way to do it.