Dear all,
I have a workbook where cost centres hierarchy node is showed on the column heather but cost centres are not in a sorted way! This month after refresh the workbook the user noted that the cost centres become sorted (as expected)! However this would impact the excel macros and formulas the user has on the excel workbook. I cannot understand the "unsorted" way how the cost centres were showed on the report but I want to keep them after refresh the query. Is there any way to achieve this? Is this related with Properties - "Adjust format after data refresh" ?
Thanks in advance
Best Regards
1 Answer
-
Best Answer
Former MemberPosted on Dec 04, 2007 at 08:00 AMhi if you have accosiated the cost center with a hierarchy and display the results as a hierarchy sorting isn't exactly as we expected.There is a compination of the chell and the node in order to perform the sorting.In general when we don't have hierarchy we do a right click and select the sorting field.But when we have a hierarchy we have to do the right click in combination with the hierarchy node we wish to sort.So the rest of the hierarchy remains unchanged and the details of the node are getting sorted.You must try and find the best combination for you result.There is a trick by adding a cell at the workbook with your custom sorting and sort the entire workbook with this cell.(like 1.2.3.4.5.6) and not with cost center.
reward if usefull.
Add a comment
Add a comment