G
gibsol
I have a large database currently 6500 lines of data but will grow to a very
large size by the end of the year.
I am attempting to analyse the data using a PivotTable View in Access.
This I have managed to a certain extent, what I am unable to accomplish is
taking my total cost and dividing it by my total QTY shown by each country
that I have costs for.
The only way I can show this unit of 1 for the costs is to enter a
Calculated Total, but, this shows every country that is in the database for
each and every cost.
Sorry to ramble on but it is difficult to explain in a few concise words.
large size by the end of the year.
I am attempting to analyse the data using a PivotTable View in Access.
This I have managed to a certain extent, what I am unable to accomplish is
taking my total cost and dividing it by my total QTY shown by each country
that I have costs for.
The only way I can show this unit of 1 for the costs is to enter a
Calculated Total, but, this shows every country that is in the database for
each and every cost.
Sorry to ramble on but it is difficult to explain in a few concise words.