Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?


Hi Julie,

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.


0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question