Monthly And Cumulative Sort

[Robbie Doo]

I created a report that shows each customer in a monthly column with the
Cumulative in the last column. However, I would like to sort the Cumulative
in a descending order, which I'm having a hard time because it is a Formula
and there's no option for that to sort.
Is there another way to do this?

 

[Evi]

Could the formula go in your Query? You could sort by it then.
Evi

 

[Robbie Doo]

I used the same Formula in the query but for some reason the formulat doesn't
work. I get an error the "SampleMonth" is not part of the aggregate function
or something like that.

 

[Evi]

Which formula are you using Robbie?


Evi

I used the same Formula in the query but for some reason the formulat doesn't
work. I get an error the "SampleMonth" is not part of the aggregate function
or something like that.