I am fairly new to BI reporting, so this is probably a simpler question for everyone else. I have a statistical report by month that subtotals by quarter. I need to have the quarter "subtotal" be the last period of the quarter. So if I have 100 for Jul, 200 for Aug, and 300 for Sep I need the Q1 subtotal to be 300 and not 600.
Can anybody help? I tried doing the lastperiods function but that doesn' seem to be working. Any help is greatly appreciated.
ballytech,
Do you have a cube or relational datasource? Also, from your description, it looks like your data is a balance of the month-over-month activity. Am I correct?