Fliter Regard to only one dimension selection

[matthewlau120]

Hi All

My question is about how to set up a set analysis formula regard to only "Outlet Dimension" in the below picture.

I need to calculate the MTD Value by each outlet. However, the MTD value is now aggregated but not in separate outlet  .

Here is the formula and the pic:

formula:=Sum({1<[check_time.autoCalendar.Year]={"$(=(year(Max(check_time))))"},[check_time.autoCalendar.Date]={">=$(=(MonthStart(Max(check_time))))<=$(=date(Max(check_time)))"}>}total_amt)

Now the JR and HC MTD Value is the same

Pic and Fliter Panel:

[pradosh_thakur]

for out let JR

=Sum({1<[check_time.autoCalendar.Year]={"$(=(year(Max(check_time))))"},[check_time.autoCalendar.Date]={">=$(=(MonthStart(Max(check_time))))<=$(=date(Max(check_time)))"},[Outlet Name]={'JR'}>}total_amt)

for HC

=Sum({1<[check_time.autoCalendar.Year]={"$(=(year(Max(check_time))))"},[check_time.autoCalendar.Date]={">=$(=(MonthStart(Max(check_time))))<=$(=date(Max(check_time)))"},[Outlet Name]={'HC'}>}total_amt)

[pradosh_thakur · Accepted solution]

For the selection to work

=Sum({1<[check_time.autoCalendar.Year]={"$(=(year(Max(check_time))))"},[check_time.autoCalendar.Date]={">=$(=(MonthStart(Max(check_time))))<=$(=date(Max(check_time)))"},[Outlet Name]=p([Outlet Name])>}total_amt)