Weighted vs total

Hello
Is there any way to calculate the weight for each category according to the main category, for example how much category 3 weighs according to the total of Apparel.

Hi @Geral

You can use the rank function to calculate the rank of each category relative to the total.

Example: (Replace the fields from your dataset)

rank
(
  [sum(Sales) ASC], 
  [Category]
)

Hi @Geral,
It’s been awhile since we last heard from you, did you have any additional questions regarding your case or were you able to find a work around?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

Hi @Geral,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!