topic Fliter Regard to only one dimension selection in App Development

Fliter Regard to only one dimension selection

matthewlau120 — Wed, 13 Feb 2019 08:19:45 GMT

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:

Re: Fliter Regard to only one dimension selection

pradosh_thakur — Wed, 13 Feb 2019 09:04:26 GMT

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)

Re: Fliter Regard to only one dimension selection

pradosh_thakur — Wed, 13 Feb 2019 09:05:41 GMT

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)