Export to Excel from Analysis by Dimensions

Dr_mjh

Hi there,

We have this case in one of our clients; We made analysis view with the expenses accounts and linked it with the department dimension then a lot of transactions made to those accounts. In analysis by dimensions we selected the G/L account as lines and department as columns. In the analysis by dimensions everything looks fine with the accounts and the departments and their amounts and when we export this to excel everything is the same -beautiful as we want it-

Here is my problem if we choose in the options -in analysis by dimensions- to show column name and then export to excel everything will be messy; parts of the departments is on the lines and not all of the accounts are listed and the dates are a part of both lines and columns. This has been very weired case to me. I even tried it on cronus and miraculously everything looked just fine :-k

Please any help with this will be greatly appreciated. [-o<

Dr_mjh

Up.