Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

order by sub sum

Hi!

sorry my english...

is anybody know how order table by sub sum?

(in attached files)

1 Solution

Accepted Solutions
thomas_skariah
Creator III
Creator III

Hi,

Find the attached application.

Regards,

Tom

View solution in original post

10 Replies
thomas_skariah
Creator III
Creator III

Hi,

You can use sort properties->properties->sort->then with first dimension sort by y-value ascending.

Hope this works.

Regards,

Tom

Not applicable
Author

Tom, thank you fo help. unfortunatly it still not working. may be need to create some formula in this field?

total.JPG

some kind of sort by formula with total

thomas_skariah
Creator III
Creator III

Hi,

Is this oder by column from the image attached on your first post is a calculated expression or a total?

Regards,

Tom

Not applicable
Author

In image this is column with total sum. this total sum is switch on by

total_sum_on.JPG

this column appear when i mark on (see above image). this sum in column because i moved field in pivot.

Not applicable
Author

i mean how i can sort by column "Show Partial Sums"

thomas_skariah
Creator III
Creator III

Hi,

If Possible can you prepare a sample application and forward.

Regards,

Tom

Not applicable
Author

Hi!

I make a sample. I need just order tabler by value of the last column.

It must be easy, but i dont get it

thomas_skariah
Creator III
Creator III

Hi,

Find the attached application.

Regards,

Tom

Not applicable
Author

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!