Add calculated field.
ifnull(sum([Po 2014]),0)+ifnull(sum([Po 2015]),0)
Then create "month" and "Year" field
[Month] // 01~12 are used for correct sorting order.
Then put table calc down the table. for [PO consolidated] with percent diff from previous
Y oY crowth 9.0.twbx 10.9 KB
In the attached workbook, I mocked up your data to include measures for PO2014 and PO2015, and then used a calculated field to be able to display them on one line. I'm not sure how you want to handle the PO LE1 line item, so I have left it out for now. It would be easy to include in the calculation if you need it. In a perfect world, your data would have not split the PO measure into two measures - one for 2014 and one for 2015, but we can easily combine them if this is the way you are getting the data.
Here are the steps:
Step 1: Create a calculated field which calculates the total based on the Year. This assumes no date overlap between the PO2014 and PO2015 measures:
IF YEAR([Month End]) = 2014 THEN
IF YEAR([Month End]) = 2015 THEN
Step 2: Drag [Month End] to Columns and set up Measure Values to use the new calculated field [Po]. Expand [Month End] to show Months.
You should now see the values on one line.
To show YOY%, you need to set up a Table Calculation on the [Po] calculated field with the following settings. I included a YOY% in the attached workbook.
Hope this helps,
PO.twbx 11.9 KB
Steve - your solution worked, but why won't it allow me to create a line chart with the percent difference?