Beast Mode Question

Chuqi_D
Chuqi_D Member
in Magic ETL

I have three column, first one is how many we gained this year, second one is how many we lost this year, and last column is total. I applied a filter, filter through this year the problem is I want total column go beyond this year, in another word, the filter won't affect it. Can I do this in beast mode, I try create a ETL but get this error message "Aggregate functions are not allowed in this context: 'SUM'. domo"

What's the best way to solve this?

Tagged:

Answers

  • GrantSmith
    GrantSmith Coach

    you can try and use a fixed function with a filter none. Try something like

    SUM(SUM(`Total`) FIXED (FILTER NONE))

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Chuqi_D
    Chuqi_D Member

    I apologize for the confusion. Each column represents a separate store, so I would like to see the total for each individual store, rather than the combined total for all stores.

Categories