Styling Total in SAC table

[Sayedzubair]

Hi Friends,

Can someone please guide on how styling can be done for "Show Totals" in table in SAC? Tried with styling rules but not getting the desired output. Any change in the no of rows switches the formatting set for the Totals to the next rows. Also, same thing happens if any row level calculation is added and formatted in a certain way. The formats shift if any new row gets added. How this can be achieved and kept more dynamic?

Regards,

Sayed Zubair

[Katryn_Cheng]

Hi there,

That's a bit strange and maybe I'm missing something. I've tried applying styles manually and through formatting the Totals cell directly and by applying a Style. In both cases, the formatting stuck with the Totals cell even after adding/removing rows and columns as it should.

Can you provide a screenshot of the issue and explain the kind of formatting you are trying to accomplish?

[karo_k]

I am experencing similar issue like katryn.cheng described in her comment from 2021. Any news or guides, how to format total rows in Table in SAC?

[paulverweij]

Hi all,

here a similar issue. Formatting works on cell and even rowlevel, but we try to make it on 'Subtotals' level. Subtotal is not a fixed rownumber of course, depends on the break level and selection. Basic question: can we apply for instance a yellow background for each subtotalrow? .

thanks, Paul

[Subhasmit]

Hi sayedzubaird,

Please go through with this link... https://subscription.packtpub.com/book/data/9781788290883/7/ch07lvl1sec62/showing-totals#:~:text=Here's%20how%20to%20show%20totals,manager%20record%20to%20show%20totals.

I think it will be helpful for you.

Thank You.

[bernd_gerlach-decampos]

Hi SAC lovers,

I'm not sure if the behavior changed with one of the constant updates, but I successfully formatted my total lines (only). To give you an example / instructions: 

1. I have a table with dimensions in rows called (1) "Solution Area" and (2) "Sub-Solution Area" and a measure column.
2. I've turned on "Show totals" on both dimensions.
3. I've clicked the first cell showing a Totals number in the Sub-Solution Area created a basic Style (blue font color, light grey cell background, alignment right) named "SubSol Style"
4. I've kept the 'cursor' in that cell and created a Styling Rule "SubSol StylingRule" with
   1. "Data" and "Header" boxes checked for dim Sub-Solution Area
   2. Level = "Self & Descendants"
   3. "Data" and "Header" boxes unchecked for dim Solution Area and Measures
   4. Chose Style "SubSol Style" 

See the result in the attached picture.

Good luck & Best Regards,
Bernd