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
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.
Ok Got it
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.
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.
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