compare two date in set analysis

[#1]

Hello all,

I have problem with comapring two date in set analysis. For example I have two table:

Tab1:

Load * inline [

date1, value1];

and

Tab2:

Load * inline [

date2, value2];

and now in pivot table I want to compare sum of value for that date, I mean: sum({<date2= date1>}value2) but it works only when I've set only one date. So then I try something like that: sum({<date2= {">=$(=min(date1))<=$(=max(date1))"}>}value2) but of course it shows one sum of value for many date. Have you got any idea how to solve it?? the problme is that It must be other table, so I can't concatenate tab1 and tab2 or join it. Please help me.

[lironbaram · Accepted solution]

hi check attah example

hope it helps you

[#3]

Yes, you are right, but here the problem is that I have many data, so I add set analysis and reduce some data. Thank you.