+3In a table, the row headings (the pivoted fields that you can view either in Tabular or Tree layout) are by default formatted with dark grey font on a light grey background. But if I want it to make it *pop* I can’t think of other way than to go row-by-row and go through the menu:
Is there a better way?
Best answer by Benoit
Indeed, this would work if you have not many items in your left column. It allows you to format only on the parent categories. However, I understand if this dimensions has more than 50 items, it could be painful.
Please note that Block formatting is a topic under revamping and your feedback will surely be taken into account for the roadmap.
In the meantime, there is a workaround that does not impact a lot your tree view and allow you to format all rows at once.
It’s to create a general parent mapping.
Let’s say in your far left column you have 100 items of dimension A.
That’s the best I can think of to unlock this case. 🙂
Hope that’d work for you.
Best,
Benoit
+15Hi Agnar,
In this static format menu, you can try to untick “only this item”, it will apply the format on all cells related to the same dimension item. If you apply this on the parent dimension, it will apply on children.
At the top of this, you can reformat a specific row if needed.
I recorded a little gif:
(there’s a limit on the image’s size allowed in posts, I’ll try to enhance this gif if I can)
Hope it would save you time ;)
Best,
Benoit
+3Hi Benoit,
Thanks for the tiny gif :) But this doesn’t seem to acheive what I’m looking for unfortunately. What I would like to do is apply formatting to all the headers in the left most column. And in a list of a few thousand rows it can become a bit tedious to do one by one ;)
Best,
Agnar
+15Indeed, this would work if you have not many items in your left column. It allows you to format only on the parent categories. However, I understand if this dimensions has more than 50 items, it could be painful.
Please note that Block formatting is a topic under revamping and your feedback will surely be taken into account for the roadmap.
In the meantime, there is a workaround that does not impact a lot your tree view and allow you to format all rows at once.
It’s to create a general parent mapping.
Let’s say in your far left column you have 100 items of dimension A.
That’s the best I can think of to unlock this case. 🙂
Hope that’d work for you.
Best,
Benoit
+8Hi
Thanks,
Sharon
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
