Share
ReportHi All
I have a scenario where i would like the report to behave differently for a specific Main account in Management reporter.
I have simplified for the purpose of this explanation..
I have the following departments:
Department A, Department B, Department B
I have the following income main accounts:
10001 - Income type 1
10002 - Income type 2
10003 - Income type 3
Income YTD is as follows:
| Financial Dimension | Total YTD |
| 10001-A | £10 |
| 10001-B | £10 |
| 10002-C | £20 |
| 10003-A | £10 |
| 10003-B | £10 |
| Total | £60 |
I have created the report row and column definitions but want the report to just give me the total for Main account 10003 in a 'other' column. I do not want to show the split by department for this Main account ,so therefore behaving differently to the 2 other Main accounts ?
| Expected report layout | |||||||
| Department A | Department B | Department C | Other | Total | |||
| 10001 | £10 | £10 | £20 | ||||
| 10002 | £20 | £20 | |||||
|
£20 | £20 | |||||
| £10 | £10 | £20 | £20 | £60 | |||
| TASK: Do not split code 10003 by department, Sum up total in 'other' Column | |||||||
Can someone please advise if this is at all possible?
Thank you in advance for any help on this matter.
Kind regards
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
1