QTD Expression Issue

[vanderson009]

Hi Community,

I have build set expression for

CY QTD as

= sum({<SalesDate={">=$(=QuarterStart(max(SalesDate)))

                                    <=$(=max(SalesDate))"},

                                    Sales_Year=,

                                    Sales_Month=,

                                    Sales_Quarter=,

                                    Sales_Day=>}Sales)

LY QTD as

=SUM({<SalesDate={">=$(=monthstart(max(Sales_QuarterStart),-12))
                                 <=$(=addmonths(max(Sales_Date),-12))"},

                                 Sales_Month=,

                                 Sales_Week=,

                                 Sales_Day=>} Sales)

Without any selection On Year and Quarter Both expression gives Sales Value.

But On Selection On Year and Quarter LY QTD not reflecting any Sales Value....

Is thr any wrong logic with LY QTD????

Thanks and Regards,

Villeyy.

[perumal_41]

Hi Villyee

Use this Expression

= sum({<SalesDate={">=$(=QuarterStart(max(SalesDate),-12))

                                    <=$(=max(SalesDate),-12)"},

                                    Sales_Year=,

                                    Sales_Month=,

                                    Sales_Quarter=,

                                    Sales_Day=>}Sales)