Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot date/sort show
I have as one of my fields in a pivot data set the date of a transaction.
The transactions are sales transactions. I need the pivot to show me the last date (or two at most) that a particular type of sale happened. I have my rows as basically acct name, Order Type (there are two main types), and I need the last time a txn happened (which would involve a "Units" field to have more than zero units, and therefore I am using this as my data) to show. Descending sort effectively gives me the last date first, but I don't want to see all the other sorts. Thx for any help. -- Boris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables: Don't show data for detail, but still show subtotals | Excel Worksheet Functions | |||
Pivot tables - how to show only show data or < $10k | Excel Discussion (Misc queries) | |||
urgent pls! sort date pivot report | Excel Discussion (Misc queries) | |||
pivot date sort/show | Excel Worksheet Functions | |||
pivot date sort/show | Excel Worksheet Functions |