How to dynamically sum rows?

304 Views

Hi Gurus,

I am facing a problem in my report. The requirement is that I have to sum every 8th row in the report starting from 1st row upto the end of the report.

For eg. I have to sum 1st,9th, 17th row and so on. The total should come after the end of the report.

I am using local members to show "TOTAL" at the end of the report.

The problem that I am facing is that the number of rows are according to the number of members of the PROFITCTR dimension of the row axis.

If we select 1 member of the dimension, then only 1st row sum should show in the bottom. If there are 2 members, then sum of 1st and 9th row should show in 17th row and so on. If I write a simple sum formula adding the cells till the maximum possible members of the dimension, then the sum is coming fine of all members are selected but it comes to 0 if any lesser members are there. I hope I am clear with the requirement.

Kindly help out.