5 Replies Latest reply on Oct 17, 2016 12:00 PM by Matt Hong

# Show percentage of total when MAX value

I have a trend line showing total applications. Total applications are composed of New + Decline + Non Responsive.

So far, I have the line showing the MAX total application and the count broken down by new, decline, and non responsive.

My goal is:

-Show the % of new, decline, non responsive in a 100% stacked bar.

-I want to show the %s described above relative to the MAX total applications.

• ###### 1. Re: Show percentage of total when MAX value

1. To create the 100% stacked bar, you should pivot those three columns. And pivot other columns (everything from Capacity to Total Apps) while you are at it.

2. It's not clear what your goal is here, as MAX is a value and the % is a percentage. What is the relative comparison task you intend to accomplish? If it would be between two percentages, what would the MAX value be divided by?

• ###### 2. Re: Show percentage of total when MAX value

Thanks for your response! I was referring to the MAX value of the total application time series. For example, let's say the MAX value (total application) for a particular school during the time framed provided is 300. Out of the 300 total applications, I would like know that 20% declined, 20% are non responsive, and 60% are new.

• ###### 3. Re: Show percentage of total when MAX value

The issue I had after pivoting was that total applications count changed since the number of records increased since it was a SUM.

• ###### 4. Re: Show percentage of total when MAX value

Hi Diogo, is this what you're looking for?

To get this, I basically divided each of your declined/new/non-responsive measures by the total, set them up to compute along DAY(Date), and edited the formatting to suit.

1 of 1 people found this helpful
• ###### 5. Re: Show percentage of total when MAX value

Here it is with pivoted data. To address your concern, the key is to use SUM({ EXCLUDE [School Code (group)]: MIN([Total Apps])}) instead of SUM([Total Apps]).