Skip to Content
author's profile photo Former Member
Former Member

Report writing with Department and Accounts in rows

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.

Dept_Acct.PNG (5.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 03, 2014 at 08:23 AM

    Hi Sean,

    If row axis is static in your report then

    1) Simply use local excel description and hide row axis.

    2) Only for display, override the description of members.

    Regards,

    Shrikant

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2014 at 02:30 PM

    Hi Sean,

    I don't quite get your point... your row heads are like this

    HEAD

    department

    department

    accounts

    department

    TOTAL

    showing members of different dimensions, isn't it? Are those rows entered manually, or how did you get them into the same column?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.