6 Replies Latest reply on May 25, 2017 7:12 AM by Jim Dehner

# Showing % of total within dimension on Line Chart

Hi All,

It seems like I continue to run into this same issue and I never am smart enough to just document how I solved the problem.  I am think it would require a LOD calculation, but please help!!!

I am using sensitive data, so I am going to have to post screenshots (sorry).  What I want to do is create a line chart the reflects the percent total across these three separate categories (A, B, C).  I want to be able to compare them relative to their own respective totals.  For instance, for "Music" I want to show A (2%) B (1%) and C (2%) on the same line chart.  Additionally, I would like to be able to switch between these programs using a filter (switch from Music to Religion for example).

What I typically get once I create a line chart with these data is their row %.

All help would be much appreciated!

• ###### 1. Re: Showing % of total within dimension on Line Chart

Not quite sure what you want to achieve,

but you can try Pane Down:

Yemeng

• ###### 2. Re: Showing % of total within dimension on Line Chart

Hi Jon

Is this what you are looking for?

reading across each LINE the total will be 100% for the 4 year time horizon -

to get there edit the table calculation as shown

a t10.2 file is attached

Let me know if this helps

Jim

• ###### 3. Re: Showing % of total within dimension on Line Chart

Hi Jim,

Thank you very much for trying to help me out.  That is in the right direction, but what I am trying to do is get the three lines to display separate column percentages for each year.  Lets just say I am looking at 2014-2015 data from the table below in English.  Again, I am sorry I cannot show you a workbook since I know that makes it 1000x easier.  So for the 2014-2015 point on the line chart, I would have 3% for Column A, 3% for Column B, and 4% for Column C.  Then if the next point in my line chart were 2015-2016, those percentages might shift to 5% for Column A, 7% for Column B, and 2% for Column C.  The problem is, I cannot get the line chart to reflect the column percentages in this table.  I end up getting something that looks like the data in the 2nd image below.  That basically shows each line as a percent of the total, instead of showing each point as a percentage of its own category (as I wanted it formatted above).  It seems simple to want to replicate the data in my table into a line chart, but it is proving to be very difficult.

• ###### 4. Re: Showing % of total within dimension on Line Chart

Ok Got it

that's this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 5. Re: Showing % of total within dimension on Line Chart

Thanks for sending that, and it is what I have been trying and I know that it has worked before.  However, it is not working in this case.  It still results in the same issue.  The structure of my data is pretty simple and it allows me to create the exact crosstab I want which I have already done.  I just cannot transfer it to a line chart.

• ###### 6. Re: Showing % of total within dimension on Line Chart

strange

It took me a couple tries to get the chart right - (not the placement of the pills on the view)

Originally I had the Sales on the marks card detail on was not getting what I wanted - need to put the category on both the detail and color tiles

Let me know if that helps

Jim