Using Greater than variable in set analysis

[#1]

Hi experts,

how to use  Greater than variable in set analysis??was it fine??

=Sum({$< Year = {$(#vYear)}, Quarter = {$(#vQuarter)} , Month = {>=$(#vMonth)}>} sales)

thanks

[#2]

hi

try this

=Sum({$< Year = {$(#vYear)}, Quarter = {">=$(#vQuarter)} , Month = {<=$(#vMonth)}>} sales)

[MK_QSL]

What you want to achieve end result?

[sujeetsingh]

Follow these

Set analysis with greater/less than or equal to a variable

Greater than or equal to a variable (set analysis)

[#5]

Hi Manish,

I want to achieve QTD sales information.

[MK_QSL]

=SUM({<Month = , Quarter =, Week = , Year= {'$(=max(Year))'}, Date = {">=$(=Date(QuarterStart(Max(Date))))<=$(=Date(QuarterEnd(Max(Date))))"}>}Sales)