Make an average of some months sales and group them on a new "month"

[Anonymous]

Hello,

I would like for 201607 to 201612, make an average of sales and rename that "month" as segment 1.

I would like always to show the Segment1.

i have attached the same data on the qwd.

I hope you can help me.

thank you

[MK_QSL · Accepted solution]

Create a Variable

vDate

=Date(YearStart(Today()),'YYYYMM')

Now use below

Calculated Dimension

=Aggr(IF(Date < $(vDate),'Segment1',Date),Date)

Expression

Avg(Aggr(SUM(Sales),Date))

[antoniotiman]

Hi Pablo,

see Attachment.

Regards,

Antonio.