Highlighted area represents one transaction related to buying or selling however posted in two rows which makes finding the difference between buy and sell values difficult. Also i would like to know the length of time elapsed inbetween buy and/or sell orders and vice versa. How can I break these columns in pivot table?
Bookmarks