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])
