Bar chart period on a bar chart, and later keep showing months

[Anonymous]

Hello,

I would like to know it there is a possibility on a graph instead of showing x months, to shorten it, make an average and later keep showing months.

for example on the photo below, i made a period form 201511 to 201610.

thank you

[MK_QSL · Accepted solution]

Dimension

=IF(OrderYearMonth < Date#('201611','YYYYMM'), 'Period',Date(OrderYearMonth,'YYYYMM'))

Expression

=IF(OrderYearMonth >= Date#('201611','YYYYMM'), SUM(Sales), Avg(Aggr(SUM(Sales),OrderYearMonth)))