How to retrieve the data by using 2 variables calculation including the year and month?

[rolasyeow]

Hi guys, sorry I'm new to Qlik Sense, the calculations I wanted is sum([Local Profit])/sum([Local SubTotal]) but I also wanted to filter it by selecting specific year and month... 

Therefore, can someone teach me how to correct this expression? I keep getting nested aggregation error message. Below is my expression ...
sum ({<Year={$(=max(Year))},Month= {"=$(=max({<Year={$(=max(Year))}>} Month))"}>} sum([Local Profit])/sum([Local SubTotal]))

[kaushiknsolanki · Accepted solution]

HI,

It should be 

sum ({<Year={$(=max(Year))},Month= {"=$(=max({<Year={$(=max(Year))}>} Month))"}>} [Local Profit])

/

sum({<Year={$(=max(Year))},Month= {"=$(=max({<Year={$(=max(Year))}>} Month))"}>}[Local SubTotal])