Creating key in datatable to not overload excel pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access datatable with millions of futures trades. I can create an
Excel pivot table but it only allows me to view grouping of trades by
product, or account. I cannot view individual trades becuase the unique
field "ID" has to many unique values. So one idea I had is to just create a
numeric key for an account's trades for the day. So if the account has 10
trades in a day a running total is created. How can I create something to do
this? Maybe there is something simpler?
 
I have an Access datatable with millions of futures trades. I can create an
Excel pivot table but it only allows me to view grouping of trades by
product, or account. I cannot view individual trades becuase the unique
field "ID" has to many unique values. So one idea I had is to just create a
numeric key for an account's trades for the day. So if the account has 10
trades in a day a running total is created. How can I create something to do
this? Maybe there is something simpler?
Click to expand...

Um?

Index the date field, and base the pivot table on a Query selecting one day's
trades.

John W. Vinson [MVP]
 
Back
Top