RE:Selected range

[Chanty4u]

hi,

how to bring cumulative sum based on selected range

consider am selecting 03/12/2105 ; I need sales till that date not YTD?

Any idea?can anyone suggest?

thanks in advance

[MK_QSL]

SUM({< Year=, Quarter=, Month=, Week=, Date = {">=$(=YearStart(Max(Date)))<=$(=Max(Date))"}>}Sales)

[Chanty4u]

thnx manish...

but its giving only selected value sum; not till date

[MK_QSL · Accepted solution]

Consider that you have selected 03/12/2105

If you want 01/01/2015 to 03/12/2015, use

SUM({< Year=, Quarter=, Month=, Week=, Date = {">=$(=YearStart(Max(Date)))<=$(=Max(Date))"}>}Sales)

If you want min Date to 03/12/2015, use

SUM({< Year=, Quarter=, Month=, Week=, Date = {">=$(=Min({1}Date))<=$(=Max(Date))"}>}Sales)

[Anonymous]

try this:

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

It will give you till date only

[Chanty4u]

can v create an tool tip for list box witout caption?

[Anonymous]

Tool tip?

like this?

Tool Tip

[Anonymous]

for tool tip:

Properties -> Caption -> HelpText (Right Bottom)

[Chanty4u]

hi manish,

dis is also not shwng the sum till date?  any other solution?

[Chanty4u]

not wrkng balraj...