on 03-23-2017 7:00 PM
Hi Friends,
I have 2 dimension in rows and I wanted to format the header for Profit center dimension with a border.
time
Account1 Profit center Level 1
| Profit center Level 2|
I have applied formatting to the header Level 2, (apply format to inner dimension). What i have noticed is it puts the border for the 1st dimension too (account). is it a bug or its behaving the way its designed.
time
Account Profit center level 1
| | | Profit Center Level 2|
as a work around i have used conditional formatting (create a rule to apply no borders if the value is NULL) to remove the border from the account dimension.
Is there a work around for this situation.
If you are talking about "Apply Format to option: If a row or column axis contains more than one dimension, you can specify to which dimension you want the defined format to be applied; the inner dimension being the last dimension, the outer dimension being the first dimension in the axis." then it's not working 🙂 And to my mind will never work - different interface has to be designed to support different formatting for different dimensions in same axis.
Use conditional formatting with the formula to get a column number:
=COLUMN()=2
to format second column.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Vadim.
The original report has bigger drill down in the profit centers with other formatting too. When we print the report it does not look good, as the formatting gets extended to the empty cells of the first row
When we specify "format on inner dimension" we expect it to be formatting on a single inner dimension. not both the dimensions. (i hope that is what it means)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Vadim for your reply.
Attached is the screen shot of a simple report with expected result and the actual result with the formatting sheet selection. capture.png
Currently I am using conditional formatting to remove formatting of the first dimension in the row structure.
I will check if I can update the tag for this question.
Thanks
Ed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, but do you really think that it's possible to help you without clear screenshots? Or you have no time?
P.S. And the question tag is incorrect, has to be: EPM Add-In for Excel
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.