I have this data in a Transaction group and want to put it into a power table. This I have completed. But where I am lost is how I could put the data in rows and columns based on the Target Name. I have a eight lane system that I want to compare raw data by rows and columns of like data, but have no clue where to start parsing the data. So the one transaction group data would fill in 8 rows of data.
I would also like to change the viewed data by date which I think I can handle once I have an Idea of how to organized the data.
I am trying to emulate a excel report that is manually entered now.
If someone can point me in the right direction I would appreciate it.