MS Access Pivot Table calculated values
Posted on 2013-01-16
I have a long list of "deals" each with a %margin on an advance (the amount the deal was for), the advance and a number of other fields e.g. manufacturer, retailer, equipment_type that I want to use as filter and I want to display the data by month (in yyyymm format - this is already calculated in the data)
I need to work with the weighted margin (margin*advance) which I have also calculated in the input query.
What I want to end up with is
(sum of weighted margin)/sum of advance
for each month which recalculates as the filter fields are applied.
Is this more than can be done in Access? :-)