Skip to Content
0
Former Member
Oct 06, 2014 at 03:52 PM

Local Member Totals in SAP BPC Report - ignore nodes if expanded

73 Views

Hi,

I want to add a total to the bottom of a BPC report but is it possible to add it so if a node is expanded it is not included in the sum. If I add the total by using the method SUM it includes the nodes and the leaves in turn get duplicate results.

Another idea i had was using adding together two nodes which would provide the value (as the descendents of two nodes was being used to display data). I tried this but it doesnt work. I am getting YTD, PERIODIC etc being displayed on the row. Note the columns axis is static.

Any ideas what I can do to show a total?

Cheers,