Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have just asked the same question but explaining the issue with my own words (english is not my first language, so it is not that easy for me to be clear).
I asked ChatGPT to help me be a litle bit clearer. Here is the following:
Here is how my graph looks like right now:
here is want i want to have:
thanks everyone in advance. i love this community.
Here is the data and all expressions used:
Data:
Data:
NoConcatenate Load
Chr(RecNo() + Ord('A') - 1) as City,
Rand() * Rand() * Rand() * 1000 as Sales
AutoGenerate 26;
Dimension:
=Aggr(Dual(City, Rank(Sum(Sales))), City)
Measure:
=RangeSum(Above(Sum(Sales), 0, RowNo())) / Sum(total Sales)
Dimension reference lines:
=Ceil(Count(distinct City) * 0.1) // Replace 0.1 with whatever percentage you want
Measure reference lines:
=Sum(Aggr(If(Rank(Sum(Sales)) <= Ceil(Count(distinct total City) * 0.1), Sum(Sales)), City)) / Sum(total Sales) // Replace 0.1 with whatever percentage you want
I hope it helps.