Transpose task in SAS EG 4.3

[pcfriendly]

Hi

I'm using the Tranpose task & am having some trouble with getting a field to appear where the 'Column' values of an Excel Pivot would be.

I'm using the Excel pivot analogy to explain what I need & make my question easier to understand.

When I start the task I select my graph icon that I want to transpose & I get the dialogue box with my table fields in the 'Name' area.

I drag each field over to the 'Task Roles' area to create the Transposed table.

I have my 'Group Analysis by' fields - this would be the 'Row' area of an Excel pivot - this presents OK.

I now want to add my calculations & I add them to the 'Transpose variables' area which would be the 'Data' area of a pivot.

The issue is I have a field that I want place in the 'Column' area of a pivot but wherever I place this field, 'Copy Variables', New Column Names' or wherever, I can't get this field to split the calculations across the top of the table in the 'Column' area of a pivot.

Hope my Excel Pivot analogy makes some sense.

Can anyone help me get the right? Cheers  

[pcfriendly]

OR maybe I'm using the wrong task???

If so, can anyone suggest how to change the table to summarise the data as one field as a list down the left side of the table eg East, West, North, South & across the top the Salespersons by names, Bill, Fred, Simon etc.

Now the Sales $ should populate the table for Bills sales in whichever region.

I'm trying a List table with one way frequency, any suggests?

[pcfriendly]

Got it,

The Summary tables task does this in case anyone wants to know.

Under Tasks >> Describe >> Summary tables Wizard. in Enterprise Guide 4.3.

Cheers