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?
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?