Straight table sales is not displaying, but my pivot table displays but missing region

[#1]

I need to display Top sales persons within the region alongwith their Sales volume, am using the below Dim  & exps, but Sales value is not getting displayed in

my Straight table. 

Other Issue is, if I convert this  straight table to Pivot table its not displaying Europe region itself but it displays the Sales value.

Can someone help me the cause for this...

Dimensions : Region, SalesPerson

Expression :  aggr(rank(sum(Sales)),Region,SP), aggr(sum(Sales),Region,SP)  

Region   SalesPerson   Rank    Sales  

Europe    Rob                   1

Europe    Brad                  2

Germany Jose                  1 

India        Ashok               1

USA        Bradi                 1

LOAD * INLINE [

Region,Quantity,Sales,Cogs,margin,profit%,month,year,SP

India,5,65,5,10,67,Jan,2009,Arul

India,15,75,5,10,67,Feb,2009,Arun

India,5,15,5,10,67,Apr,2011,Ashok

India,8,24,12,12,50,Apr,2009,Gowtam

India,8,24,12,12,50,Apr,2010,Sasi

USA,50,200,100,100,50,Apr,2010,Uttam

USA,5,100,60,40,40,Apr,2011,Bradi

Europe,10,50,16,24,60,May,2010,Joe

Europe,8,40,16,24,60,Apr,2010,Sam

Europe,4,20,16,24,60,Apr,2010,Brad

Europe,100,400,200,200,50,May,2011,Brad

Europe,100,504,204,200,50,Apr,2011,Rob

Germany,10,50,30,20,40,Apr,2009,Peter

Germany,20,100,30,20,40,Apr,2010,Tom

Germany,25,200,100,100,50,Apr,2011,Jose

];