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
Categories
- All Categories
- 1.8K Forums
- 1.7K Platform
- 109 Academy
- 283 Resources
- 3 Community Captains
- 1 About Community Captains
- 1 Meet the Community Captains
- 1 Topics & Thought Starters
- Board Manual
- 50 Best Practices
- 42 How-To Guides
- 25 Board Advocacy Program
- 159 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- Academy
- 2 Board Academy
- 7 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.1K Idea Exchange
- 310 Partner Hub
- 2 Solution Sales Toolkits
- 92 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP