I'm probably just choosing the wrong metric or need to add some tables to bridge the data gap, but i am looking to create a matrix-like visualization that gives me both a count of cash receipt transactions, and their total in separate rows. The viz is pulling from a table of individual cash receipts.
I created 2 matrix visuals and overlapped them to give the impression of what i'm looking to do, but as the values change, they fall out of line with each other, and it starts to look wonky, as seen below.
My data is basically:
Company | Doc Date | Doc Number | Doc Amnt