Hi,
This seems simple but I am having trouble. I have a simple pivot table with ID as the row field, and then I want my data items displayed across not down. The default view is that each row field (ie ID) then has a rows for the data items (Sum of Amount, Sum of Paid, etc.) I want each data field listed in its own column. Basically I just want to flip the report.
Any ideas of how to do this? I greatly appreciate any help!
ps. I tried in table options changing the format to "over, then down" but nothing happens.
This seems simple but I am having trouble. I have a simple pivot table with ID as the row field, and then I want my data items displayed across not down. The default view is that each row field (ie ID) then has a rows for the data items (Sum of Amount, Sum of Paid, etc.) I want each data field listed in its own column. Basically I just want to flip the report.
Any ideas of how to do this? I greatly appreciate any help!
ps. I tried in table options changing the format to "over, then down" but nothing happens.