Skip to Content
0
Former Member
Aug 29, 2008 at 02:48 PM

Display average for line items

29 Views

I have a query with a fixed row structure basically line items restricting on specific cost centers. I have my column structure where my key figures are alone with date restrictions, etc. Part of my query requires the user to specify the date interval for the data they want to see: Production date: 8/01/2008 - 8/12/2008 for example, but instead of the total for that date range for each line item in my row structure, they want to see the month-to-date average of the production for that time period. I have tried to do the option of Average for all values under the local calculations, but it still gives me the total, so I'm assuming that only applies to the result rows. The option for aggregation is grayed out. Temporarily, I have given them an input variable to enter 12 for the number of days and done the division in a formula, but I don't want to continue to have to do that if there is a better way.