Can someone tell me why when I use the Dimension Limit 80% of Relative Total Using Largest Value, the lowest value is included?
Below are all my values sorted Descending (this is the first expression and I only have one Dimension)
and this is what I get when I set the dimension limit to accumulate to 80% of Relative Total Using Largest Value
shouldn't the record with a total of $5000 come next?
You can't sort by y-values in a straight table (x & y don't exist). I tried sorting my dimension with first priority descending by the same expression formula and that didn't change anything.
I added a % of total column and this is confusing me even more. You reach 80% at the 10,265 line, so why are the other 3 included? Is it sorting individual records and taking the top 80% before aggregation and then including records that aren't in the 80% in the aggregated result?
Every day I work in QV I wish I was working in Tableau again.
I have already noticed this behaviour due to values < 0.
You don't use Dimension limits.
You use expression
If(RangeSum(Above(Sum(Sales),0,RowNo()))/Sum(TOTAL Sales) <= 0.8,Sum(Sales))