145
I have one row format for my P&L with many lines (for example sales). I want to use this row format for departmental reprting, but the departments do not have many of the lines. Is there a way to use the 1 row format but hide the lines that do not contain data for the departments?
*This post is locked for comments
On this I think the last 4 digit is account code if I am right. So other than that I would fill all other segment with ??? as follows. Since you are giving filter on Tree. So I would fill required account code in row if its not defined in tree. And leave the tree as it is. If you want to define some more account segment in row itself then don't use that again on tree instead just put ? on that.
10 Sales - USA C NP ????-?-010-0000
20 Sales - Correction to Subledger C NP ????-?-010-9998
30 Sales - Export C NP ????-?-010-9999
40 Sales - PY C NP ????-?-010-0001
60 Sales Returns and Allowances ????-?-030-0000
100 Cost of Sales @ Standard 1000-?-060-0000 +(1000-?-060-0005)
Product Testing ????-?-???-6219
Test Floors ????-?-???-6220
please try and confirm whether its works for you
10 Sales - USA C NP ????-4-010-0000
20 Sales - Correction to Subledger C NP ????-4-410-9998
30 Sales - Export C NP ????-4-410-9999
40 Sales - PY C NP ????-4-010-0001
50 Gross Sales TOT 10 TO 40
60 Sales Returns and Allowances ????-4-030-0000
70 ---
80 Net Sales TOT 50-60
90 DES
100 Cost of Sales @ Standard 1000-4-060-0000 +(1000-4-060-0005)
110 ---
120 Gross Profit @ Standard TOT 80-100
130 % to sales CAL @120/@80 "#,###0.0%;(#,##.0%)
140 DES
This is the marketing part
Product Testing ????-6-230-6219
Test Floors ????-6-230-6220
The Tree
KARN Total Marketing Total Marketing
KARN 5-231 Central ????-5-231-????
KARN 6-230 Exhibits ????-6-230-????
KARN 6-231 Commerical ????-6-231-????
KARN 6-232 Retail ????-6-232-????
KARN 6-233 HPZ ????-6-233-????
KARN 6-234 Other ????-6-234-????
The results
Actual Budget
Gross Sales 34,254,654 0
Sales Returns and Allowances 2,248,578 0
- -
Net Sales 32,006,076 0
Cost of Sales @ Standard 18,556,594 0
- -
Gross Profit @ Standard 13,449,482 0
Variances
PPV 6,803 0
Brochures & Literature 250,206 379,782
Presenters 561,710 348,000
Outbound Freight - Marketing 5,145 148,296
Mktg Accrual-MM 0 (308,574)
- -
Marketing Materials 817,061 567,504
Thank you for your help
can you send me the screen shot of row, column and tree
That is what I thought but it did not work. Our acct structure is "company" "control" "dept" "acct"
so I have my rows set as follows:
????-6-???-6309 - the 6 indicates marketing
The Tree lists all the departments in MKTG (231/232/233/234/235/236)
I was getting duplicate values for every acct in mktg and I was getting all the details from my P&L row even if they didn't apply to marketing
I am thinking the rows using ???? vs &&&& and the tree using ???? for the acct structure is causing the problem - but I am at a loss
This can be achieved easily. You can have one row and column and have one tree with all the department listed on that i.e. 100-????-??? (Marketing). So when you run it will asked user to select the department and the result will come Marketing only. So in this way when you add new account you have to add only one time in the row format. Please confirm whether this solve your problem.
Thanks,
Babu
No - I did this - for example I have the following lines:
Sales
COS
GM
Freight
Market Spending by line item
I want only market spending by line item to print for the department Marketing - yet I get the sales/COS/GH/Freight numbers also
I must be doing something wrong in the rows (I use ???? maybe need to uswe &&&&)
I solved this by creating rows for each segment but now I have to update 10 rows if an acct is added vs 1 row
Are you referring the output generated from the FRX has rows with no numbers on that. If so you might have selected display rows with no amounts on the report option tab. If this is not the case please explain in detail what you are trying to do.
Thanks,
babu
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
