I'm using a query which shows the total spend DDP/EUR per month per profit centre (given by the profit centre). I have also added what the total should be (COGS 5999 or 1300).
I would like to add (in the query) the percentage of reported total spend
As -> total spend (given by company) / COGS 5999 = ..%
How can I put that in my query? As I do not know where to place it (i.e. under which fieldname, in the criteria range, what the formula should be etc)
Expand|Select|Wrap|Line Numbers
- SELECT DISTINCTROW Spend.PcCode, Profit_centre.[Profit centre name], Spend.YEAR, Spend.MONTH, Sum(Spend.[Total spend DDP/EUR]) AS [SumOfTotal spend DDP/EUR], COGS.[5999], COGS.[1300]
I hope you can help me