I have executed a Query and Saved it as a Workbook. Before Saving it a a Workbook , I changed the Layout of the Workkbook, by bringing the KeyFigures next to the relevant characteristics .Basicallly The keyfigures are displayed towards the Right End of the Query Result or in the BEx Report. So, I changed the layout int he Workbook in such a way that the first few columns conatin Characteristics adn then Keyfigures,then Characteristics.
Now when I execute the workbook Initiallly it displays the Same Layout with whatever Data I have loaded during the Last Execution of The Report.
But when I refresh the Query or when i change the Variable Values, It again goes back to the query Layout and My Layout is not Saved.
How do I save my Workbook Layout Permanently so that even if it is Refreshed or the Variable Values are changed, The Layout Remains the same?
Thanks and Regards,