Stimulsoft Business Intelligence System | Forum

Posted: **Thu Jun 27, 2019 11:47 pm**

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 !!

Posted: **Mon Jul 01, 2019 7:31 am**

Hello,

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

Thank you.

Posted: **Wed Aug 14, 2019 6:02 am**

Table.xlsx: (18.16 KiB) Downloaded 185 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.

Posted: **Thu Aug 15, 2019 7:45 am**

Hello,

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

Thank you.

Stimulsoft Business Intelligence System | Forum

Calculate total in a table :Dashboard

Calculate total in a table :Dashboard

Re: Calculate total in a table :Dashboard

Re: Calculate total in a table :Dashboard

Re: Calculate total in a table :Dashboard