I have an excel sheet (see attached), in 1st sheet I have a dataset with Euro, in 2nd sheet I have dataset with USD, I want to achieve the 3rd sheet using Qlikview i.e. I have to combine both data sources (usd and euro) and consolidate it in one sheet (as shown in the 3rd consolidated sheet).
The datasource has the following hierarchy/structure
without space I have company
3 spaces before I have a group
5 spaces before I have a product
company total = total of groups
group total = total of products
Number of products (under specific group) can vary in datasets.