My client, BPC 10 MS, has a reporting need both Departments and Accounts being in the rows. For example, in the photo below the first two rows are departments, the third is a group of accounts and the fourth is a department. And then a subtotal is needed.
I am thinking a heirarchy will help but this is accross dimensions. Then I thought maybe copy the data to a different grouping of accounts to facilitate.
Any ideas or suggestions.
- SAP Managed Tags:
Accepted Solutions (1)
Hi Sean,
You can not add two dimensions in single column.
If your report is static, As I mentioned before , crate report by shifting row axis , and hide the row axis , Give the description as per your requirement.
PFA screen shot -
Regards,
Shrikant
The report will not be static. Here is what I did for one section of the report. And may have to do it for others as well. Their are additional requirements that will make this a challenging one as well.
I made two reports: One with projects in the row axis and one without. I then used the formula in the function bar (as a local member) to summarize the data.
What do you think?
An additional requirement is that in one section I will need to have NET_SALES projects as ALL and the license revenue expanded. Can this be done in one report?
Answers (1)
| User | Count |
|---|---|
| 16 | |
| 3 | |
| 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.