Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 date sort/show | Excel Worksheet Functions | |||
Using Date Grouping in Pivot Tables | Excel Discussion (Misc queries) | |||
Date Format Pivot Grouping | Excel Discussion (Misc queries) | |||
How to group date in pivot table | Excel Discussion (Misc queries) | |||
Date Selection for Pivot Table | Excel Discussion (Misc queries) |