requirement

[Anonymous]

I have a requirement where I need to calculate sum(some field)

now I have two tables in my script(both having yearmonth flag),

sum(field) will be calculated when say yearmonth of table 1 is dec2017 den I need to take sum(field) where yearmonth in field2 shud be nov2017(I month befoe),

how I shud incorporate in set analysis

[bramkn]

Your question is a bit confusing to me.

You have 2 tables with the same data?

is this field yearmonth qualified for the table it is in? or do you have a kalendar?

[Anonymous]

data is different in both tables

[bramkn]

so

sum({<yearmonthfield1={'dec2017'}>}field1)

sum({<yearmonthfield2={'nov2017'}>}field2)

?

[Anonymous]

something like this:

sum({<yearmonth={'201712'},yearmonth2={'201711'}>}field)

[PrashantSangle]

How do you load it ??

when concatenate it are you creating any flag??

try like

sum({<flag={'Table 1'},yearMonth={"$(=max(yearMonth))"}>}field)-

sum({<flag={'Table 2'},yearMonth={"$(=AddMonths(max(yearMonth),-1))"}>}field)

Regards,

[bramkn]

with numbers you don't need the ''

if this is what you are looking for yes this should work. Without samples I can't help much more.