Forum Discussion

iDataDrew's avatar
iDataDrew
Advocate IV
9 years ago

Filtering on Summarized Table

I have a summarized table showing new customers from the most recent week.  I also have a page-level filter of states (e.g. NY, NJ, OH) that is from the original table.  When no filters are in place,...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi iDataDrew,

 

You can use a variable to store the summary table, then use filter function to filter records.

 

For example:

 

New Table=
Var temp= Summarize(AWL,[account_weekly_log_date],[start_date],[end_date],[name],[cust_id],[accept_date],[Utility],[account_status_id],[iso],[State],[Commodity],"RCE",SUM(AWL[RCE]))
return
Filter(temp,AND([account_status_id]=1,[end_date]>[start_date])&&AND([accept_date]>=max([account_weekly_log_date])-7,[accept_date]<max([account_weekly_log_date])))

 

If above not help, please provide a sample file to test.

 

Regards,

Xiaoxin Sheng

iDataDrew's avatar
iDataDrew
Advocate IV
9 years ago

Anonymous isn't that essentially the same thing that I have, only using a variable?  

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi iDataDrew,

     

    >>isn't that essentially the same thing that I have, only using a variable?

     

    Since the summary table is a new table which unnamed in the formula, I'd like to suggest you direct use column name to call new table column.(original table's column may doesn't work on new table)

     

     

    Regards,

    Xiaoxin Sheng