How to custom 2 columns on X-axis to be the same level in the waterfall chart

Hi, I got some requirements for showing 2 types of value in a waterfall chart. it must be used 2 columns at the same level. the first column is from [Year] for showing the total value of last year, the second column is [category] for showing the different values between last year and the current year for each category.  [Year] and [category] must be at the same level on X-axis.

Is there any way to choose 2 columns on X-axis by using the IF-ELSE statement and the 2 columns still at the same level? 

 

Thank you so much

Login