Using GetSummary

[sam81]

I have following data set

 

Unique ID        Product ID   submode                 Region       Sales

  1                        x                   x1                          US               10

  2                        x                   x1                          EU               20

  3                        x                   x2                           EU               30

  4                        x                   x2                          US               40

  5                        y                   y1                          JPY              50

  6                        y                   y1                          US               60

 

 

now i need to add the sales based on product and region level 

 

 

x    US   50

x     EU   50  and so on...................i know i can use sub summary reports but I need the valyes (50 and 50) in a field since i need to do further analysis of this field . I tried using getsummary(SummarySales,Region) but I got nothing. Not sure what I am missing. 

[comment]

 I tried using getsummary(SummarySales,Region) but I got nothing.

 

Records must be sorted in order to use GetSummary(). Note that you will get different results with different sort orders.

[sam81]

I sorted the data based on Region...but I get blank..