How can we give a specific colour to Subtotals in a schema?

Aaron_Yohannan
2 days ago
3replies
Answered

Hi,

I found this older discussion in the Q&As, https://community.pyramidanalytics.com/t/g9hqrlc/how-can-we-identify-which-part-of-a-theme-to-change can anyone please guide where we can give color to Subtotals in themes and then we can see them in export/ printing to excel.

Regards,

Aaron Y

- Aaron_Yohannan
- 2 days ago
- Reported - view
Hi,

Can anyone please guide where we can give color to Subtotals in themes and then we can see them in export/ printing to excel.

Regards,

Aaron Y
- Lead Consultant Advanced Analytics
  
  Michael_Daun
  
  yesterday
  
  Reported - view
  - as far as I see this does not work by means of the design theme.
  
  In the design theme you define - besides colors for fonts, lines or background 16 "Report Colors" ("Report color #1" - "Report Color #16"). In a grid these colors are used to color the background of the columns and rows and of the corresponding headers in the grid (At the same time these colors are used for the colorization of lines or columns in charts - but this is another topic).
  
  The colorization of a grid with the means of the design theme is illustratred below:
  
  You see, Report Colors with odd numbers are used for the columns, Report Colors with even numbers are used for the rows. You can adapt these general colorization by the use of a Grid Design, which more or less overwrites the theme's formatting for a specific grid.
  
  When it comes to Sub Totals it gets a little bit complicated, which hopefully is illustrated by the next screenshot:
  
  The colors you can see here do not come directly from the design theme - they seem to be color gradations from the theme colors. So, if at all, you can only define these indirectly. Again, try the effects of the Grid Designs here as well - or format them individually and manually.
  
  Hope this helps!
  Michael
- Senior Director of Product
- Ian_Macdonald
- yesterday
- Reported - view
Hi ,

is correct in that the subtotals colour is set in the grid formatting, not the theme.

Click on the Format control when in the Grid sub menu:

then click one of the subtotals. You'll notice they are all highlighted (You can use this technique to colour specific members as well):

Choose a background colour form the grid formatting options:

Done.

Hope that helps.

Ian