Hello,
I have a crosstab with columns showing different measures. I need to show a summary line of all the measures.
My issue is that some of my measures need to be aggregated (aggregate function) and some need to be totalled up (total function). How do I mix up these functions in a single line. I thought of having different calculated data items and showing them by defining data contents to "Yes" in individual cells. It doesn't work. Any help would be greatly appreciated?
Hi,
The title mentions a cube, so I assume this is a dimensional package?
Is it as simple as adding a new query calculation below the final row with the expression aggregate(currentMeasure within set [your set of row members])
Cheers!
MF.
Hi MF,
Thanks for the reply. I have created data items for each measure (rather than dragging each measure into the query) and changed rollup aggregations individually and it worked like a magic. Simple thing..had to post this to get a quick answer to meet my deadline....
Thanks...