[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3681.Sourcetest.xlsx:550:0]
Dear Ladies and Gentlemen,
I'm struggeling with the load of an Privot Table from Excel.
It looks like this:
It outcome should be to Table structure like this importet in Qlikview:
Category | Product | YearMonth | Quantity | Amount | Avg Price |
I've tried with crosstable functions but nothing gave the format needed.
Thanks for your help!