GetSelectedCount with sumif

[christianeatman]

Hi,

I am trying to display a KPI for a certain year if no selection is made in the year filter. Specifically, I want to show the sum of an amount for the year 2018 if no selection is made. It seems from my research that GetSelectedCount would allow me to do this. This is what I tried, but does not work:

sum(if(GetSelectedCount([Sheet1.Year]=0) and{<[Sheet1.Year]={2018}>}),Amount)

I have tried this expression in various forms (different placement of commas, different placement of parentheses, placing the sum in a different place), but nothing has worked. Is it possible to accomplish what I want using GetSelectedCount? If not, are there other ways to do this?

Thanks!

[sunny_talwar]

Try this

If(GetSelectedCount([Sheet1.Year]) = 0, Count({<[Sheet1.Year] = {2018}>}[Emplid])/Count({<[Sheet1.Year] = {2018}>}EMPLID_PIT), Count([Emplid])/Count(EMPLID_PIT))

[christianeatman]

That works.  I really appreciate you guys' help!