It is hard to tell what the answer might be with out seeing the workbook. If it's possible can you include an example workbook?
In Desktop, right click on the sheet and select 'Duplicate as crosstab'
The cross tab view may be helpful for editing so that the export works the way that is needed.
Yes. I think we may be a bit stuck here. However, I was able to hide the headers of Shipping and Quantity. Those two fields will not show in the view, but they will show in the Excel cross tab.
I formated Sales and Profit to have a background color of blue, and the profit ratio is now just to the right of Profit.
Is this getting close?
Thanks for work around .
But i need the measures in between the Columns which i had issued because for my visualization i need to show all
and export to Excel and need to get rid of Null Values .
Will it be possible to put measures i.e means row containing in between Columns.
I'm not sure what is meant by 'measures in between columns'.
The other way to get the column order is to use measure names and values, however the color mark gets applied to all measures.
Are the Null values the result of the calculated fields? Or are there actually Nulls in the data?
The null values are coming because of using calculated fields. Can i have your skype id so that i will explain in you a better way