cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cosminc Member
Member

table date by month with years & evolution till ytd

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 

 

 

 

 

 

 

 

YearMonthNoSalesmanSales
20191George80
20181George62
20182George74
20183George49
20184George28
20185George51
20186George73
20187George53
20188George75
20189George30
201810George98
201811George22
201812George97
20171George20
20172George42
20173George57
20174George24
20175George27
20176George41
20177George46
20178George19
20179George63
201710George28
201711George85
201712George74

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: table date by month with years & evolution till ytd

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 Member
Member

Re: table date by month with years & evolution till ytd

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