Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have a reqruirment. How to sort Composite Key.. For this i am Sharing a qvw. in this A bar garph..i want to sort year month Key.Please Help me For sorting Issue
May be use a sort expression:
=Date#(Key, 'YYYY-MMM')
or you can change your script:
RegionSales:
Load * Inline
[ Region, Year, Month, Sales
North, 2014, 5, 245
North, 2014, 5, 347
North, 2014, 6, 127
South, 2014, 6, 645
South, 2013, 5, 367
South, 2013, 5, 221
East, 2012, 7, 203
West, 2011, 8, 289
];
Tab:
Load*,
Dual(Year&'-'&month(makedate(2001,Month,1)),Year&Month) As Key
Resident RegionSales;
Drop Table RegionSales;