sorry my english...
is anybody know how order table by sub sum?
(in attached files)
You can use sort properties->properties->sort->then with first dimension sort by y-value ascending.
Hope this works.
Tom, thank you fo help. unfortunatly it still not working. may be need to create some formula in this field?
some kind of sort by formula with total
Is this oder by column from the image attached on your first post is a calculated expression or a total?
In image this is column with total sum. this total sum is switch on by
this column appear when i mark on (see above image). this sum in column because i moved field in pivot.
i mean how i can sort by column "Show Partial Sums"
If Possible can you prepare a sample application and forward.
I make a sample. I need just order tabler by value of the last column.
It must be easy, but i dont get it
Find the attached application.
Tom, thank you!
Could you take a look on little sample whith count function?
I need the same thing - order by last column.
thank you for help!
Thank you very much Tom!!!!
it is working perfecty!!!
Retrieving data ...