Set values ​​in the dynamic table

[fabio182]

Dear experts, A favor I need your support for the next case. With the following script I show the USD data of the last day for each month. SUM (aggr (if (Period = MAX (total <Period2> Period), USD), GROUP, NOMOFC, Code, RUC2, Name, Type, Period2, Day, IDRegistro)) What I need is that when I use the filters of year, month, day, etc. the value of 201812 stays fixed without needing to move but when I filter the days of 2019 filter the values.

[sunny_talwar]

Would you be able to share your app to test this out?