I am getting line items & their values in cube. But I need to show the header value i.e. the totals of line items in Bex. for the header value column, I need to show 7000. How can I achieve this in Bex?
Document Item itemvalue headervalue
1 10 2000