Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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 | Other Legacy |
REVENUE | 2010 NBS |
REVENUE | 2011 NBS |
REVENUE | 2012 NBS |
REVENUE | 2013 NBS |
REVENUE | Provision for refunds |
VARIABLE COSTS | Provider Payments |
VARIABLE COSTS | Administrative Fees |
Only straight table.... need to change the category...