% of total

How to calculate Value/(total value in column), %

------------------------------
Vasily Feofanov
Analyst
Limited Liability Company "Super Brands"
Russian Federation
------------------------------

Find more posts tagged with

Accepted answers

All comments

Sebastian Gurt

Hi @Vasily Feofanov,

you can either add an alogrithm where you calculate a/dt(a) . The formula dt(a) takes the downtotal of block a. Or you add a ranking function Vertical % which gives you the same result. Check this out: Ranking functions.

BR

Sebastian

------------------------------
Sebastian Gurt
Consultant Team Leader
Board International
Germany
------------------------------
-------------------------------------------

Jon De Leon

Hi @Sebastian Gurt ,
Is there somewhere I can see all of the algorithm structures/shortcuts (i.e. "dt" means downtotal)?

Thanks!

------------------------------
Jon De Leon
Manager, Financial Analytics

United States
------------------------------
-------------------------------------------

unknown

Hi @Jon De Leon,

yes that's right, dt means downtotal.

Here you can find information about column algorithm.

You may also need information about the reverse algorithm

Kind regards
Tobias

------------------------------
Tobias Hahn-Wiltschek
Junior Consultant
Board Community
Germany
------------------------------
-------------------------------------------

Jon De Leon

Thank you @Tobias Hahn-Wiltschek !
That was very helpful!

------------------------------
Jon De Leon
Manager, Financial Analytics

United States
------------------------------
-------------------------------------------

Catalina

Hello!

Thank you for these explanations! I have an additional situation for which I need help. I need to have in the same table a top 10 ranking and also a column showing the % of the top 10 in the total. When I put the dt formula in a table where I already have the top 10, it does only the addition of the top 10 but not of the whole table.

thank you!

Catalina

Project Manager, France

Leone Scaburri

Hello @Catalina,

you can't get it calculated on the fly on your layout. You should calculate the % through a dataflow on the whole population, then you can show just top 10 members.

Catalina

Hello @Leone Scaburri,

Thank you for your quick reply, it helps.

Catalina

Gary Beardsley

Hi @Vasily Feofanov,

Another commonly used formula would be rt(a), which uses the row total value.

I thought I would mention this as it is one of my personal favourites :)

Gary