Show Total but with a default value

Question & Answer
,
1

Hello,
I have 2 columns: rate% and target% by a category. The target% is hard-coded such that for each category I have a specific target.
I want to add in my visual the “Totals by Rows” but I want the Total rate_target% to be a default value not the aggregation of row-level values (aka I have a hard-coded value by category and for total).

Example:

Immagine 2024-11-18 145342
Immagine 2024-11-18 145342379×208 20.3 KB

Is that feasible?
Thanks

2

Hi @Francesca
if you want to use table calculation i think it will not work.
but you could create a “total” category and set it default for target and based on calculation for rate.
BR