on 08-31-2015 8:46 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.