Percent of total

John Hughes

I've got a data view where I've broken down sales into several categories. How can I get the percentage of the total sales for each of these categories in an adjacent column?

Alexander Kappes

Hi,

the solution will be using Column Algorithm with DT or GT function.

More details for this you can find here:

https://www.boardmanual.com/2021/summer/capsules/screens/2_Objects/The_Layout/Layout_Data_Blocks/Column_Algorithm.htm?rhsearch=dt&rhhlterm=dt

Hope it helps

regards

Alex

Philipp Schumacher

Hi John,

you can also use the Ranking Function Percent %

Kind regards

Philipp

John Hughes

https://community.board.com/discussion/comment/14263#Comment_14263

@Alexander Kappes that got me close using the GT algorithm, but it's totaling off the second entity I have on my row. I'm trying to get it to total off of the total in that cube for a particular year.

Alexander Kappes

@John Hughes , you mean something like that?

In my case I used Nexel. My Standard Layout looks like:

The Nexel Formular looks like:

Hope it helps

regards

Alex

John Hughes

@Alexander Kappes how did you get the 391.1 K in the downtotal?

Alexander Kappes

@John Hughes you mean the K (number Scaling)? This is new Feature starting with 12.5 and can be configured for each single DataView.

Alexander Kappes

Dear John,

thanks for your request.

The solution will be using DataView functions, in your case dt Downtotal

More Information you can find here: https://www.boardmanual.com/2021/summer/capsules/screens/2_Objects/The_Layout/Layout_Data_Blocks/Column_Algorithm.htm?rhsearch=dt&rhhlterm=dt

Attached a little case from my local machine, which should be similar to your case

I´m using the Downtotal for the Sum of the Salesperson. Using GT will use the grandtotal line.

Hope it helps

regards

Alex