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

3

HI @Francesca
any updates?
BR

4

Thanks for your answer @ErikG.
The only solution I found at the moment is to split the visuals into 2 visuals: one with numbers by category and one with totals (as a 4th category).

Happy to hear other solutions.

5

Hi @Francesca,
It’s been awhile since last communication took place on this thread. I believe your work around may be the best option for this as like Erik mentioned, I’m not sure this is currently possible.

Let us know if you have any additional questions, otherwise, if we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

6

Hi @Francesca,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!