How do I collectively categorize/group the transaction details with similar entries (such as 'Business Payment from' or 'Customer Transfer to') so that I can later do a summary and pivot them?
How do I collectively categorize/group the transaction details with similar entries (such as 'Business Payment from' or 'Customer Transfer to') so that I can later do a summary and pivot them?
Hi,
You can do this by adding a column in the original Table with group name for each row corresponding to that group or, in Pivot select rows you want to group, right click and Group. Do this for each group of rows you need
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
I can work with this. Thanks a bunch for your time!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks