답변 1개
Hi @Iestyn Humphreys,
Are you still looking for this - 6 months later?
By cumulative cost curve, is this just a cumulative histogram? Though you could use anything as the x axis.
Using Superstore, this only needs a single calculation for the cumulative, though the cumulative is expressed as a percentage, with the distributions also expressed as a percentage, so you'll need a calculation for this too.
1/ Bin you measure, we'll use Sales, set Bins as 500
2/ Perc total:
Sum(Sales) / Total(Sum(Sales))
3/ Cumulative perc total:
Running_Sum(Sum(Sales)) / Total(Sum(Sales))
4/ Format both calcs to percentage
5/ Drag Sales(Bin) to Columns
6/ Drag Perc Total and Cumulative perc total onto the rows
7/ Dual axis, setting Perc total mark as bar, and the Cumulative perc total as a line
Does this help?
Steve
