08-23-2012 07:42 PM
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
08-23-2012 09:25 PM
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?