I have a table which has multiple dimension and no measure added. One of these dimension is in number format (Say Column-N). Upon exporting to excel this particular column displays in improper format as 123456+E and so on.
However, i am aware of the fact that upon adding it to measure, it shall solve the issue but the problem is if we add Column-N to measure then irrespective of the order in table, it shifts to last column. I want it to be in particular order so as to make sense for analysis.