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.....
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.