In the pivot grid I see where I can sort on Row but I don't see how to sort on Data column. I often want to sort alphabetically on Row(IE: Client Name) and then sort descending on particular data column. I don't see how to do this. Is there a way? Or can this be added?
I don't really see that as a work around. It is an important issue that Hyperion Brio can do and Toad cannot. The expectation is that the two products work the same in key areas. I am starting to make a list of these issues. I will be rolling out over a hundred conversions from Brio to Toad Workbook and have to explain these differences to the end users. We will see how well these differences go over.
Note: The order of Rows is not what is important in this case. Often when you pivot you want to see the value of the highest column descending. The sequence of rows does not matter. The sequence of one particular data column is what the whole pivot is about. It is very hard on the eyes/brain to sift through unsorted data.
I would like to also request this feature - I have lots of Pivots that need to be sorted in desc dollar data order. It seems to be an option in Dimensional Views.
Just to clarify - I'm referring to the Pivot Grid step in Toad Workbook
In TDP 6.2 , we've implemented some enhancements to the sorting functionality in the Pivot grid. Detailed information can be found in the official Release Notes under the "New Features" section:
https://support.quest.com/technical-documents/toad-data-point/6.2/release-notes#TOPIC-2138016
Feel free to give the latest version a test drive and share your feedback or suggestions for improvements.
Its working great in 6.2! Thank you for adding this feature!
1 Like