scecchin
New Member
Hi
I am trying to summarize costs from a transactions table into a report by the group I have assigned to payees in a reference table. To get the correct value I would read the transactions table, take the payee, look it up in the reference table that shows the payee and the group it is assigned to, (for example Royal Dutch Shell would be assigned to the "Automobile" group. Other gasoline suppliers would also be assigned to the same group.) The report would then add all the gasoline amounts in the transaction table, based on the common grouping of "Automobile"
I have attached an example file if that helps
Thank you
Sergio
I am trying to summarize costs from a transactions table into a report by the group I have assigned to payees in a reference table. To get the correct value I would read the transactions table, take the payee, look it up in the reference table that shows the payee and the group it is assigned to, (for example Royal Dutch Shell would be assigned to the "Automobile" group. Other gasoline suppliers would also be assigned to the same group.) The report would then add all the gasoline amounts in the transaction table, based on the common grouping of "Automobile"
I have attached an example file if that helps
Thank you
Sergio