Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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)
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)
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)