Hello,
I am creating a report that will deliver seperate pages for: YTD, Prior YTD, Prior Month, Prior Month Last Year and each quarter for the current and prior fiscal year. I am having issues with delivering the QTD pages. The PowerPlay Cube has a "FYTD Grouped, Last Month" relative time period, which delivers all of the time periods I am looking for. I created a master query which delivers each of the prior FY Quarters. I used this query in a list on the Quarter pages, then set-up a master detail relationship using the Quarters query item for the join. The head delivers the correct quarter value (FY 2015 Q 1), but the crosstab contains the total for both quarters. If the crosstab simply had different members on the rows and columns, this approach would work, but I using logic as follows in my columns:
total ( [Actual Amount] within set [GROSS_SALES], [Quarters] )
Does anyone have another approach for me to take with this?
thanks,
Mike