Hello everyone,
Maybe a strange question but i will try to be as clear as possible.
For a presentation of finance data i would like to present the last 8 years. The finance data i want to show there is the last month of the Fiscal year. This works right now with this Measure;
-sum({1<CompanyCode=p(CompanyCode),MonthNum={"$(=max(MonthNum))"},%Key_FI=p(%Key_FI)>}[#AGGR Closing Period]).
Now i want to use the drill down option that if a user selects a year, that the user drillsdown to all periods that year, now is just shows the Max. Is this possible to let go of the max when you drilldown? and if so, how?