Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
May be this:
Sum({$<[Fiscal Year]={"$(=Only([Fiscal Year]))"}, [Fiscal Period]>} [Sales])