Set Analyses

[francisvandergr]

I have a formula in a Straight table.

sum({ $ < Year = {$(#=only( Year2 ))}> } Sales)

I wanna compare 2 periods. I have four important fields for it :

Year

Month

Year2

Month2

Formula above works for Year2. When i select year2 in my dashboard, i see all sales of the selected period. Now i wanna extend my formula with month2.

It must be possible to selct more months.

Can someone help me with the formula incl. Month2.

Thnx

Francis

[#2]

Hi

All you should need to do is add the formula using a comma to seperate it. Therefore it should look something like this

sum({ $ < Year = {$(#=only( Year2 ))}> },{ $ < Month = {$(#=only( Month2 ))}> } Sales)

Regards

[francisvandergr · Accepted solution]

The easiest way to compare is with bookmarks in this way