How to make waterfall chart

[bluetronics]

Hello Experts,

Pls. teach me how to treat data and make waterfall cahart from the table below:

A. Table for sales

B. Group by year to make waterfall chart

C. What I would like to make:

Data Table

Item	CY2017	CY2018	CY2019	CY2020
A	696,513.60	1,588,204.80	2,121,228.00	-
A	85,190,400.00	58,863,104.00	67,107,160.00	15,359,680.00
B	4,316,359.20	1,023,045.12	-	-
C	7,951,188.00	21,537,792.00	15,688,252.80	4,567,449.60
C	44,413,064.40	63,159,575.04	68,156,742.72	63,781,171.20
D	33,756,696.00	36,444,539.00	32,428,307.50	7,607,841.50
A	53,031,024.00	57,253,566.00	50,944,155.00	12,239,745.00
A	41,530,320.00	28,695,763.20	-	-
B	27,953,100.00	40,238,450.00	35,804,125.00	4,199,912.50
D	14,567,558.40	15,727,485.60	22,390,876.80	5,253,010.56
C	22,362,480.00	9,657,228.00	8,592,990.00	2,015,958.00
A	20,765,160.00	17,934,852.00	15,958,410.00	3,743,922.00
B	30,881,520.00	18,670,640.80	18,986,416.00	4,454,307.20
C	10,116,360.00	8,737,492.00	7,774,610.00	1,823,962.00
D	22,362,480.00	22,073,664.00	22,096,260.00	4,031,916.00
B	29,135,116.80	22,018,479.84	22,390,876.80	5,253,010.56

Thanks in advance.

[v-chuncz-msft · Accepted solution]

@bluetronics ,

You may select Unpivot Columns in Query Editor and take a look at this post.

[bluetronics]

@v-chuncz-msft 

Thank you for your feedback.

Do I unpivot all columns like picture below? or Do I unpivot Sales Revenue columns only?