Count function on a column to get total for two areas

gbrown
gbrown Member
in Magic ETL

I am trying to do a function to give me two number totals for locations by product line. The item number is a sublevel of the product line and I want to see how many of:

for example 'Electric Cooktops' are in the red section and how many are in the green section. It might be an aggregation problem but the rank and window/ formulas are giving me trouble thanks

6kjjCapture.JPG


Tagged:

Answers

  • GrantSmith
    GrantSmith Coach

    Have you looked into subtotals on the table card and having your red/green column be your subgroupings?

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

    You could also try a beast mode similar to:


    COUNT(`Item`)over(partition by `Plant`, `Product Line`, `Color`)

Categories