Calculate total in a table :Dashboard

[Sriha]

Hello,

I need help in calculating % of Total column where each row value should divide with Sum of all values of Sales.

Time Sales % of Total
6:00 AM 100 6.06%
7:00 AM 150 9.09%
8:00 AM 200 12.12%
9:00 AM 300 18.18%
10:00 AM 400 24.24%
11:00 AM 500 30.30%


Thank you !!

[Lech Kulikowski]

Hello,

You can add DataTransformation with SumRinning and then use it in the DataBoards elements.

Thank you.

[Sriha]

Table.xlsx

(18.16 KiB) Downloaded 164 times

Hello,

I couldnt find a way to calculate. Would you be able to help me please ?

I have attached a sample report and excel - Looking for a % Sales field like in attached excel to replicate in my dashboard.

[Lech Kulikowski]

Hello,

You can set Actions - Show As Percentages
Please check the following article:
https://www.stimulsoft.com/en/documenta ... mation.htm

Thank you.