Forum Discussion
Sub-category columns Excel
Hi All, I am trying to create a report from an excel file but my file data is set-up such that the column has a sub category. e.g I have this as an excel format, how do I subcategorize ...
Hi,
I solved a similar problem here - Rearrange a multi heading dataset into a single heading one which is Pivot ready.
Hope this helps.
Hi HotChili,
I want my data to be something drillable in the columns section. So basically drill per country and then per city.
Many thanks,
Matt
OK, I would like you to be more specific please. Draw a picture or show me a tabular version of what your data should look like before it gets put into a visualisation