Dimensional function to calculate specific row cells totals

[callmenagendra]

Hi,

I created a cube and published it as a package. I am using this package to build reports in report studio.
In rows i have payors.
In columns i have measures(charges,payments,receipts,Account Balance)
i want to display columns with each measure totals.
Is there any function to calculate totals for specific columns. Please suggest..

Please find the attachment for reference.


Thanks in Advance.....

[Lynn]

Wouldn't adding QTD and YTD be double counting? And adding in PYTD kind of makes it a really nonsensical number I think.

You should be able to click on your QTD member in the report and then CTRL+click on the YTD member and PYTD member and use the calculate button to do the addition. Then nest your measure beneath that new calculated member.