Sorting issue on a column in a pivot table KPI

Q&A
, ,
1

Hello guys , please i got this issue on a kpi and i don’t understand why it’s not working ,
It’s a pivot table and i want to sort it on a column (let’s call it C) DESC only with clicking on the column C and clicking sort=> DESC
Did this ever happen to you or there is some way to fix it please ?
Thank you

2

Hi @sattia

Can you please share more information on this sort issue ?
Is it throwing any error ? can you share screenshot of error ?

3

Hi @sattia
How or where would you expect the sort option as well?
BR

4

Here is an example of the error
you can see in the columns that it is not ordered DESC
Sans titre

5

Hi @sattia
as i cant see the full pivot i tried to rebuild it

i added the sort on product_brand column with sort by product_cost.

grafik
grafik1315×730 105 KB

As you can see the sort is working on sum of product_brand (mid table). As long as you are showing more columns you have to sort the product_cost as well (right table).

BR

6

Hello @sattia !

Was @ErikG or @Ashok 's suggestions above helpful and if so could you mark one of their comments as the solution to help the community?

It has been some time since we have heard from you but we would still like to help you find a solution. If we do not hear from you in the next 3 business days this post will be archived.