Skip to Content
0
Oct 23, 2015 at 01:04 AM

Calculated Members based on data not in cross tab?

35 Views

Hi,

I am doing some financial reporting for a customer.

They want a P & L showing the actual values for each month, and a grand total showing the total for the year.

After the grand total, they want to show the annual budget, and the Last Year values.

Can I draw the values into a calculated member with out having to add the monthly columns, then make them white & as narrow as possible, leading to a report that goes over two pages?