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?