cancel
Showing results for 
Search instead for 
Did you mean: 

Percent of Total

phoebemomo
Explorer
0 Kudos

Good day!

I have a Trend chart in Story that I'm trying to display % of total instead of the employee count by Tenure in Years.

My X-Axis contains Tenure in Years and my Y-Axis contains the employee count.

For example: if I have 100 in Year 0, 100 in Year 1, 100 in Year 2 and 100 in Year 3.... my total employee count is 400. How do I create the measure to show 25% for each Year (100/400)?

phoebemomo
Explorer
0 Kudos

Figured it out by adding a measure using Grandtotal() function.

Accepted Solutions (0)

Answers (0)