Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
Richard van der Beek  
#1 Posted : Wednesday, October 17, 2018 1:15:56 PM(UTC)
Richard van der Beek
Rank: Newbie

Groups: extranet\Forum
Joined: 10/17/2018(UTC)
Posts: 1

Please tell me how to sort a measure per subtotal when using two dimension on the same axis in a crosstab.
#2 Posted : Wednesday, October 17, 2018 1:29:43 PM(UTC)
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 490

Hi Richard,

A normal sorting would sort it by subtotals - but you cannot prevent it from sorting on lower levels at the same time.

Notice the 'Hierarchical collation' option (in the right click sorting menu), which may have an effect on the sort order in a hierarchy.

BR / Ole
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.