Reverse order of dimension

[k_burata]

Hi All,

How do you reverse the order of the dimension without affecting the values? Tried sorting dimension in reverse order but getting the wrong values.

TIA.

[jyothish8807]

Hi Kim,

As far as i know you cannot achieve the same output with "Full Accumulation" on , since it will consider the max month as first month and do the calculation from the bottom.

The best solution in this case is to use Rangesum(above).

Br,

KC

[k_burata]

Hi KC,

Problem is I don't get the same values when I reverse the dimension. I would like to sort it Apr --> Jan and not Jan --> Apr. Is there like a function that would just flip the chart without changing the values?

Regards,

[ogautier62]

Hi,

RangeSum(bottom) ?

[jyothish8807]

You can sort the rangesum chart by setting Y axis decending in sort

[jyothish8807 · Accepted solution]

refer the attached.

[sunny_talwar]

You can also try this expression

=Sum(TOTAL {<[Group]>} Qty) - RangeSum(Above(Sum({<[Group]>} Qty), 1, RowNo()))