RE:Max in Quarter

[Chanty4u]

Hi all,

I have  a  fileds lik 

orderdate,

year,

quarter,

month

day,

so  in quarter i hve  Q1,Q2,Q3,Q4

so i need to Pick   Q2 max month  in set analysis 

how can i get this  Max month?

/Thanks in advance.

Best

Chanty

[Gysbert_Wassenaar]

Max(Month)?

[settu_periasamy]

May be like this?

quarter={'Q2'},month={"$(=Max(Month))"}

[Chanty4u]

Hi settu,

set analysis i want to pick max month in Quarter 2 .my field name is qtr 1,2,3,4,

eg:sum({<FY={$(=Max(FY))},Qtr={'2'},MonthOrder = {"$(= max({<FY={$(=max(FY))}>} MonthOrder)-8)"}>} Amount)

[tamilarasu]

Hi Chanty,

What is the MonthOrder field values? What are you trying to acheive with this field?

[agni_gold]

=Max({<Quarter={'Q2'}>}Month)

[sunny_talwar · Accepted solution]

I think this should work. But if you have 1, 2, 3, 4 in Quarter field thin this:

=Max({<Quarter = {2}>}Month)

[Kushal_Chawda]

try this

=sum({<FY={"$(=Max(FY))"},Qtr={"2"},MonthOrder = {"$(= max({<FY={"$(=max(FY))"},Qtr={"2"}>} MonthOrder))"}>} Amount)