EYEGUY Icon    Posts: 1543 Joined: 12/12/2003 Location: BALDWINSVILLE, NEW YORK  User Profile | Creating the second table you show with the MarketState and the Individual Strategies was a bit more difficult. First I copied the G/L($) Column so that it was contiguous with the MarketState and Strategy Column. I then highlighted the three columns (not shown). I chose Insert....Pivot Column and selected to display the resultant Pivot Table at $M$3 on the current page. I was then presented with a check box menu for the Pivot Table Fields as shown: I hope this helps anyone else who, like me, might not be familiar with Pivot Tables in Excel. Tom Helget [Edited by EYEGUY on 3/15/2018 12:08 PM]  Attached file : Creating a New Excel Pivot Table.PNG (409KB - 2009 downloads) |
