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!