Hello! I have question!
I want to sort value by code not click on pivot table.
I know the way to sort value by clicking on pivot table.
when I clicked value header column as right button of mouse, context menu(sort column desc, sort column asc) comes up.
I thought that sorting value as code function is exist because sorting value as clicking function is exist.
Do you have any API, please let me know the api 🙂
I forgot detailed. I want to sort total value on right end side as code.
Is it possible by using ‘sortValues’?
I tried it before, but I failed.
I’ll appreciate it if you give me some samples.
Thank you for a quick update!
Yes, sorting the total value is possible via
sortValues. For example,
Total Sum of Revenue column from our demo can be sorted this way:
tuple parameter is used to identify the column or row. In a case when we want to apply sorting to the total value, we specify
Does it help?
Your answer was so clarifying.