GM - Here is the idea on how I would do it. I am following this path considering that we are not changing anything in the load script and completely relying on the document expressions. You can also work with the load script to load the hierarchies. However, below is the idea on how you can achieve this with expressions & variables.
I had declared 3 variables, something like this...
vMaxYear : Max({$} Trade_Year)
vMaxMonth : Max({$} Trade_Month)
vMaxDate : Max({$} Trade_Date)
The above variables gives the maximum values for Year, Month & Date. Now we will use the variables in the chart expressions. Here is the sample expression... You need tweak this expression with nested IF's.
Just an example:
=IF( GetFieldSelections(Trade_Date) = ISNULL,
sum({$<Trade_Year = {$(=($(vMaxYear)))}>} [Index]),
sum({$<Trade_Year = {$(=($(vMaxYear)))}, Trade_Date ={'$(=($(vMaxDate)))'}>} [Index])
)
If the Trade_Date does not contain a selection then it should lookup the relevant expression based on your logic. You need to use nested IF's and use the relevant Set Analysis Expressions and the values are calculated based the field selection.
I hope this all makes sense. Let me know if you need further help.
Good luck!
Cheers - DV
.png "Luminary Alumni"){kind=icon}