1 Reply Latest reply: Jan 11, 2017 12:16 PM by Sunny Talwar RSS

    Multiple selections in Set Analysis

    Andrew Roberts

      We use Fiscal Year and Fiscal Period to define years and months respectively. Using the function below I'm able to return the YTD numbers based on the Fiscal Year selected in the filter pane above the table. The typical user selects a period and year though. How can I modify this expression to ignore the Fiscal Period filter when applied?

       

      sum({$<[Fiscal Year]={"$(=Only([Fiscal Year]))"}>} [Sales])