cancel
Showing results for 
Search instead for 
Did you mean: 

Report question: calc sum of shown elements

Former Member
0 Kudos

Hi,

I have a report writing question. My report has account, entity and intco as the row axis dimensions and time as the colum axis dimension. The members for account are selected via a property on the account dimension, for entity and intco the selection is BASE MEMBERS. The report then removes all empty and zero rows.

At this stage it looks like this:

What I now need is one total line for each account. If I add the top node to both the entity and intco dimension I get several totals calculated in the report, what I am looking for is just one total per account for all entity/intco combinations shown.

I have tried to use a local member but haven't manage to get a dynamic total for each account (and also new accounts as and when they are created).

Just to visualise, this is what the report should look like:

Hay anyone got a solution for this problem?

Thanks,

Arnold

Accepted Solutions (1)

Accepted Solutions (1)

Shrikant_Jadhav
Active Contributor
0 Kudos

Hi Arnold,

Go to - Edit report- > Account dimension member selector - > Member Sorting & Grouping - > Enable Member sorting & Grouping - > Ascending - > Group by property - > Select "ID" - > After group - > Create local member .

Shrikant

Shrikant_Jadhav
Active Contributor
0 Kudos

P.S.

Shrikant

Former Member
0 Kudos

Hi Shrikant,

thanks!

BR,
Arnold

Answers (0)