Hi!
I am doing a report that has 2 parameters - a year (prompt) and quarters (promptmany).
The report calculated indicators "Sales" and "Returns" for the selected quarters and cumulatively "RunTotalSales","RunTotalReturns" since the beginning of the selected year to the selected quarter (including).
Example: I selected 2014 and 2,4 quarters. Report shows:
Quote2Q 2014 Sales - 5 RunTotalSales - 10, Returns 0 RunTotalReturns 0
4Q 2014 Sales - 7 RunTotalSales - 23, Returns 2 RunTotalReturns 3
Report build on DMR. Running-total calculated as:
Quotetotal([Sales] within set
periodsToDate([Reports].[SalesDate].[Year_Quarter].[Year],
currentMember([Reports].[SalesDate].[Year_Quarter]))
total([Returns] within set
periodsToDate([Reports].[ReturnsDate].[Year_Quarter].[Year],
currentMember([Reports].[ReturnsDate].[Year_Quarter]))
)
Because there are quarters in which there is no returns and / or there are no sales, then I need to link both computations with the general measurement of time - "Calendar" through Master-Detail relations. But when i made it I have got error:
QuoteXQE-PLN-0015 The query is not supported. It contains a detail filter affecting a hierarchy projected by a relative member function.
Do you have any ideas how to solve this problem or can be otherwise restructure Report?
Thanks!