Re: Issue with rows calculations
I have a requirement in the report where the summation of the columns is required. In the below screenshot Profit center is in the rows and
rest of all are key figures. There are 4 profit centers and as per the user the calculations should be such a way that
Row 1 1 should display the Gross Sales and LE1 gross sales s
Row 2 should be blank
Row 5 NDT total should be the summation of rows 3 and row 4
Row 6 is blank
Row 7 should be the summation of Row 1 + Row 2 + Row 5 which is Total. ( To achieve this in OB gross Sales I have changed the Calculate results
I request you to let me know the possible way to achieve this. This a priority requirement. Please let me know your valuable suggestions
Nanda Anantha replied
- Create Structure first
- Right click on ROW Structure->Select Selection and Restrict with profit center value , do like this up to 7
- And then Right click on COLUMNS structure -->Select formula against each profit center and write formula repeat this step up to 7 times.
Hope you understand.