3 Replies Latest reply: Apr 18, 2017 4:50 AM by S Satti RSS

    How to restrict a measure?

    Sara Novillo

      Hi

      Sorry if it sounds silly but i want to use a KPI to display sales for current quarter independently of what selection user make.

      I tried Sum({<[Date.autoCalendar.YearQuarter]={'2017-Q1'}>}Sales) and it works.

      How can I make the year-quarter value dynamic instead of fix value? I want the KPI to display current year-quarter data.