July 15, 2014 at 2:12 am
I have data as below in a table
RegionTransactionsProductionValue
EASTSales LUX 1000
EASTSales Cinthol1500
EASTPurchases LUX 1000
EASTPurchases Cinthol1500
NORTHSales LUX 3000
NORTHSales Cinthol3500
NORTHPurchases LUX 3000
NORTHPurchases Cinthol3500
SOUTHSales LUX4000
SOUTHSales Cinthol 4500
SOUTHPurchases LUX 4000
SOUTHPurchases Cinthol 4500
WESTSales LUX2000
WESTSales Cinthol 2500
WESTPurchases LUX 2000
WESTPurchases Cinthol2500
I want a query to get the data as below.
LUX CINTHOL
RegionSALESPURCHASESSALESPURCHASES
EAST10001000 15001500
WEST20002000 25002500
NORTH30003000 35003500
SOUTH40004000 45004500
July 15, 2014 at 8:25 am
You could easily use CROSS TABS to pivot your data.
Read the following article and come back if you need extra help. 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply