Sort with total issue

[sergio0592]

Hi all,

In a bar chart, i add total with checking "Show total" in dimension limits tab. So, i get in my attached sample :

Country A, B, C, D and Total

But i'am unable to make a descending sort, with Total at the top, after country D, country A,...etc

Any idea?

Thanks

[sunny_talwar]

Am I the only one seeing '(Virus scan in progress...)' or everyone else is also seeing this?

[marcus_malinow]

Me too

[sunny_talwar · Accepted solution]

Looks like it is back now....

Try this

Fact:
LOAD * INLINE [
    Country, Sales
    A, 45
    B, 12
    C, 36
    D, 78
];

Dim:
LOAD * INLINE [
    Dim
    1
    2
];

and then dimension

=Pick(Dim, Country, 'Total')

Expression

Sum(Sales)

Sorting - Select sorting by Y-value Descending

[sergio0592]

Great, thank you!!