Filtering out the values of [Fiscal Year] == '2016/17' (and/or '2015/16')
would remove the Marks where [Fiscal Week] == 52 (and/or 53) from the view --
including the densified Marks (made by the 'opposing' Dimension pills on Rows / Columns).
And you're right, having a domain-complete datasource as the Primary
(so every possible combination of the [Fiscal Year] and [Fiscal Week] is present)
and using both Budget and Actuals as Secondary would resolve the filter issue.
As an (inelegant) workaround you may want to use a Table Calculation Filter
(instead of a Regular Dimension one). The calculation would be like this:
LOOKUP( ATTR( [Fiscal Year] ) ,0 )
and set to Compute using --> Cell.
The Table Calc Filter would be hiding Marks (not removing),
so the data densification would still occur (which is welcome in this case).
And selecting the #Missing value on the Table Calc Filter would do the trick.
Please find the attached.
Example for Forum_v10.5_YF.twbx 24.8 MB
Thank you so much. Even though there are still some caveats, I can use this as a base to work on.
Can't believe I didn't think of this.
Tim, you're welcome.