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