table date by month with years & evolution till ytd

[cosminc]

hi

i have a table like bellow (the bigger one) and need to obtain a table with row monthNo and columns  Sales for year1 and year0 and evolution; subtotal bellow; but only for YTD, if we have data till apr 2019 the table have to be like this

Month    2019     2018      %evolution

1

2

3

4

              total    total       %total jan-apr    

thanks,

Cosmin 

Year	MonthNo	Salesman	Sales
2019	1	George	80
2018	1	George	62
2018	2	George	74
2018	3	George	49
2018	4	George	28
2018	5	George	51
2018	6	George	73
2018	7	George	53
2018	8	George	75
2018	9	George	30
2018	10	George	98
2018	11	George	22
2018	12	George	97
2017	1	George	20
2017	2	George	42
2017	3	George	57
2017	4	George	24
2017	5	George	27
2017	6	George	41
2017	7	George	46
2017	8	George	19
2017	9	George	63
2017	10	George	28
2017	11	George	85
2017	12	George	74

[v-juanli-msft]

Hi @cosminc

Do you add "Year" column in the slicer to select which years to show or only let "2018,2019" show on the visual?

In your example, Does the total under "2018" should be total values from 2018/1~2018/12 or 2018/1~2018/4?

What does "but only for YTD" mean?

Best Regards

Maggie

[cosminc]

Hi,

these 2 graphs will be fixed - the filters will not be active on them

like a slide for a presentation with updates only when the source are changing

2018/1~2018/4

What does "but only for YTD" mean? - it means that i want to compare same period on time, not full previus year

thanks,

Cosmin