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?
Hi,
the solution will be using Column Algorithm with DT or GT function.
More details for this you can find here:
Hope it helps
regards
Alex
Hi John,
you can also use the Ranking Function Percent %
Kind regards
Philipp
@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.
@John Hughes , you mean something like that?
In my case I used Nexel. My Standard Layout looks like:
The Nexel Formular looks like:
@Alexander Kappes how did you get the 391.1 K in the downtotal?
@John Hughes you mean the K (number Scaling)? This is new Feature starting with 12.5 and can be configured for each single DataView.
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.
