Dimension value order changes when multiple data is loaded from excel
Hi everyone, this would be my first post in this community, pardon me if I have posted at the wrong place.
I am facing some issue after loading data from Excel data source, hope I can get some help with this. I’m trying to display the financial results of few companies in a pivot table. The results will change based on a list box selection. I can get it to work till this part but the issue here is the order of the dimension change when I load more than one company. It could either from few different sheets of all from one sheet. The order should be like below
But instead it comes out like below
Not all of it are off the order but just some, but the actual order is what needed. I have attached the excel document and qlikview document if its needed.