Calculated Members based on data not in cross tab?
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?
Abhilash Kumar replied
The only to way to insert a calculated member 'after' the Total column is to:
1) Disable the Total column
2) Insert the Total as a calculated member
This way you can control which calculated member column displays where.
And yes, you'd need displays strings for all columns.