I have a pivot table in Excel to be loaded to Qlikview. I have already used CrossTable and reformated the table. And that's fine.
My problem is the dimensions. They are in a pivoted categorized form as follows.
(Bold ones are main category and the next column is the sub category)
Is there a way to load them to table columns as follows? (Without using another categories matching up table)
|REVENUE||Provision for refunds|
|VARIABLE COSTS||Provider Payments|
|VARIABLE COSTS||Administrative Fees|