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.
Thank you in advance for the help.
Vivek