Not working as expected when I use normal count and set analysis count in if condition

[samp]

Using below logic.

By default it should calculate last Quarter for all the years which looks fine for me, but when I select Year and Quarter Q1 I am getting Jan, Feb, Mar, Apr, May, Jun as below image instead Jan, Feb, Mar. Here I am using pivot chart with time drill Year-->Quarter.

if(GetSelectedCount(Year)>=1 or GetSelectedCount(Quarter)>=1, 

count(TimeSpent),

count({<Quarter={$(vLastQuarter)}>}TimeSpent))

It looks it is simple but I feel I am missing something.

For my testing count(TimeSpent) is working as expected, issue is when try to show defaults for last Quarter with the above logic.

appreciate for your help.

Not Ok if I select current Quarter:

Ok if I select last Quarter  with the above if condition or simple count(TimeSpent).

[arvind_patil]

Hi Sam,

Please  try below Expression:

count({<Quarter={'$(=maxString(Quarter))'}>}TimeSpent))

Thanks,

Arvind Patil

[agigliotti]

first of all check your variable vLastQuarter content using a textbox.