Set analysis in TimeChart

[#1]

I have a time chart to compare Bookings By product to the previous quarter. Problem is I only want to show 4 products. I would normally just change the expression using set analysis. But the way time charts create the graph they use this formula:

Sum(if (InQuarterToDate (Date, Today(), -4),BookedAmount))

The dimension I am using is called product. How can I make this graph only show the three products I am interested in?

I apparently can't change the formula so that {$<Product = {'Product1','Product2','Product3'}>} )

[tresesco]

Give a try: Normal 0 false false false EN-IN X-NONE X-NONE

Sum( If(Match(Product , 'Product1','Product2','Product3')<>0 AND if (InQuarterToDate (Date, Today(), -4)),BookedAmount))

Regards, tresesco

[#3]

Thanks, this worked after I took the extra if out.

if (InQuarterToDate (Date, Today(), -4))

Became just

InQuarterToDate (Date, Today(), -4)

[tresesco]

yes, that was a silly mistake. however, it solved your problem, that is more important.