Skip to Content
author's profile photo Former Member
Former Member

Bex report Heather - keep layout

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 08:00 AM

    hi 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
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Andreas,

      Thanks for your reply. This was usefull although I have found what caused my problem and it's not rocket cience! What happen is that the cost centres order on this cost centre hierarchy node were manually changed. Therefore, on the report, that was showing cost centres sorted as the hierarchy, the order changed as well.

      As short term fix I will change back the hierarchy node. As long term I have requested the report to be based on cost centre ascending order.

      Best Regards

      Eduardo Francisco

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.