Hi community,
I have a table with business name, units, manufacturers. each business name could have multiple manufacturers.
I want to have a plan table with the field of business name to only show manufacturers count larger than 1 and its units% less than 60%. tried this at dimension of business name. but does not work out.
any idea?
=aggr(only({<[Business Name]={"=count(distinct Manufacturer) > 1"},
max(aggr(sum([Pack Units]),[Business Name],Manufacturer))
/
sum([Pack Units])={'<60%'}>
} [Business Name]),[Business Name])