Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
Hi Sam,
Please try below Expression:
count({<Quarter={'$(=maxString(Quarter))'}>}TimeSpent))
Thanks,
Arvind Patil
first of all check your variable vLastQuarter content using a textbox.