1 of 1 people found this helpful
The Gini coefficient formula requires some sort of index or ranking (the i term in the formula) and the only way to do that natively in Tableau is to use a table calculation. Table calculations compute over the dimensions in the view (not the underlying data), so what you'd need to do is bring a lower-level dimension like Product Name in the view (i.e. computing the Gini coefficient of products within each sub-category), set the compute using to that lower level dimension, and then because the view would have a dimension you don't want and a bunch of extra marks then you'd use a table calculation like INDEX() or FIRST() with the filter set to 1 or 0, respectively, to filter out the extra marks (after the Gini coefficient is applied).
Thanks for the explanation.
You, Sir, are definitely a generator of good karma in this world!