Percent of total
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?
Answers
-
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
0 -
Hi John,
you can also use the Ranking Function Percent %
Kind regards
Philipp
2 -
@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.
0 -
@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
0 -
@Alexander Kappes how did you get the 391.1 K in the downtotal?
0 -
@John Hughes you mean the K (number Scaling)? This is new Feature starting with 12.5 and can be configured for each single DataView.
0 -
Dear John,
thanks for your request.
The solution will be using DataView functions, in your case dt Downtotal
More Information you can find here:
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
0
