ending balance for OTBI - General Leader Transactional Balance Real Time

Summary

I need to show in the same OTBI report the beginning and ending balance for a period name and the sum of the year (based on the period name)

Content

Hi 

I am doing a OTBI report based on the subject area General Leader Transactional Balance Real Time and I need to show in the same row based on the natural account the beginning balance and ending balance for a specific period name (its a a prompt in the OTBI analysis) but once the user choose a period name I need to show also in the results the balance of the year.