Pivot Table - Hidden Data

B

Beth

Hello

I have got a pivot table showing today's transactions by account number.

I found that say an account has three receipts for £500 then it will be laid
out like this

Account No Account Balance Tran Amount Tran Type Unique Ref
12345A £4,000 £500 Q 123
Q
124
Q
125

What I would prefer is for the transaction amount to be shown for each
transaction.

I can make this work by putting the unique reference before the transaction
amount - however when I do that I cannot get the transaction amounts to be in
order

Any ideas?

Thanks
Beth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top