I wish to sort the row (customers) by the date of their first invoice. This should enable be to see the build-up of revenue by customer. See attached for desired result.. I wish to sort customer by the date of their first invoice within the pivot table if possible. I wish to sort the row by an inactive field (invoice date). Thanks
Last edited by Derek Cavanagh; 11-19-2013 at 10:44 PM.
In E2 Cell Tye
#
In E3 Cell
=IF(COUNTIF($A$3:A3,A3)=1,COUNTIF($B$3:$B$18,"<="&B3),VLOOKUP(A3,$A$3:E3,5,0))
Drag it down…
Place the cursor in PT and Change the Data Source to include the New Column>> Data!$A$2:$E$18
Drag and drop the # field in the first place of Row Field.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you very much. That works perfect. I'm not sure how but I'll go now and work through it..teach a man to fist...
Glad it helps you and thanks for the feedback and rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks