Count function on a column to get total for two areas

gbrown

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

GrantSmith

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

nikky

You could also try a beast mode similar to:

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