Set Analysis help

[samvile18]

Afternoon all,

Can someone help me with the following please?

I need some set analysis that will give me the sum of my FUM based on the MonthEnd of my date field.

My date field is called FExtractDate and it needs to sum everything that is the same as MonthEnd(MaxDate)

Thanks in advance guys.

[MayilVahanan]

HI

Try

MonthEnd(FExtractDate) as dimension

sum(Sales) as Expression

Hope it helps

[samvile18]

That's not applicable here as I've already got my dimensions set to something else, the syntax actually needs to be within the set analysis.

[lironbaram]

hi you can try

sum({<FExtractDate={"$(=MonthEnd(MaxDate))"}>}FUM)

let me know if it helps

[samvile18]

Hi Liron,

Unfortunately I can't get that syntax to work 😞

[lironbaram]

could you post a sample data

with the fields you use with your expression

or a least your expression syntax