Min and Max Sales By MonthWise

[vanderson009]

Hi Community,

I have one issue related Max and Min sales by MonthWise.

I am trying to calculated Max and Min Sales but couldnt do it.

i have attached QVW, Please help me.

Thanks and Regards,

Villyee.

[VishalWaghole · Accepted solution]

PFA

Hope it will help you.

For Maximum Sales = aggr(max(Sales),CalenderMonth)

For Minimum Sales = aggr(min(Sales),CalenderMonth)

Thanks and Regards,

Vishal Waghole

[MayilVahanan]

Hi

Can you say, what's couldn't do it?

Max and Min Sales

Dimension - CalendarMonth

Exp1: Min(Sales)

Exp2: Max(Sales)