M$ | 2011-11-01 | 2011-12-01 | 2012-01-01 | 2012-02-01 | |
Interest | 5000 | 450 | 375 | 500 | |
Fees | 500 | 390 | 500 | 20 | |
Rebates | 630 | 785 | 999 | 1000 |
Hi - How do I flip these so that they are listing the categories across the top and the dates along the side, with the dollar amounts for each as the data?
Can't seem to figure out the transpose tool.
thanks!
Solved! Go to Solution.
you should be able to use the Transpose tool first (Key fields = M$) (Data Fields = All other fields)
Add formula after transpose and modify the Value field with the following formula:
'$'+[Value]
Then follow that with the cross tab tool where:
group data by: Name
New Column Headers: M$
Values for new columns: Value
you can also format the numbers in a table tool if you are going to render it later anyway.