Hi -
I am working on a trended financial report in a crosstab. I have my elements down the left side, my months, quarters and years as the top headers. I have broken my report by qtrs and yrs. I need to drop the QTD metric for each element, but it is not a sum of the PTD metrics. It is actually the QTD metric for that quarter. I tried
=<QTD ACT> ForEach <Qtr & Year>
my <Qtr & Year> is a concatenated object for each qtr. but that gives me the total for the quarters. For 2Q03, I really need the QTD metrics for Jun 03, for 3Q03 I need QTD for Sep 03 … and so on.
Do I sound stressed? i am.
8)
I hope this example helps. I have added a QTD column, to show the metric that I was hoping to get in the 2Q03. The final report should only have PTD metrics and the quarter metrics.
I know logically that I need to have an object that uses the max(month) in a quarter to get the metrics for that quarter. But I have not been able to create that successfully…