Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Hidden Data
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table- force rows with no data to be hidden | Excel Discussion (Misc queries) | |||
Pivot Table - How to keep data hidden | Excel Worksheet Functions | |||
Sort Pivot Table using hidden data field | Excel Discussion (Misc queries) | |||
Pivot Table On Hidden Rows | Excel Discussion (Misc queries) | |||
Pivot Table unable to Include Hidden Items In Subtotals | Excel Discussion (Misc queries) |