Heat Map Account Combinations

Hi,

I’m working with some GL report data and trying to transform it so I can visualise the most common account combinations across journals, I think using a heat map (although very much open to suggestions). But I’m stuck on how to structure the data for this analysis.

My report looks like this:

“Document” header contains journals numbers and journals are broken down over multiple rows so that each account impacted in a journal gets it’s own row.

What I’m aiming to do is identify the most common combinations of accounts that appear together in journal entries. For example:

• Accounts A & C appear together in 25 journals

• Accounts B & D in 40

• Accounts E & F in 10

My thinking is that I can then flip this logic to identify the odd journals where the combination is rarely used.

I cannot for the life of me figure out how to arrange the data to be able to identify these combinations though. If anyone has any advice it would be amazingly helpful.

Thank you in advance for any help you can provide,