dynamic total

[satishqlik]

Hi community,

How to calculate dynamically total sales which is not based on maxdate which should be based on seletion

If select any month of the corresponding year then total sales should display

Sum({<Date = {'>=$(=monthstart(max(Date),-2))<=$(=max(Date))'}>}sales)

It returns only based on maxdate.

Any Ideas??

[#2]

Hi,

try this

Sum({$<Date = {'>=$(=monthstart(max(Date),-2))<=$(=max(Date))'}>}Amount)

-Joyson G

[sunny_talwar]

Not sure I completely understand. You want to see last three months and total as the current month?

[satishqlik]

Yes Sunny!!

But which is not based on maxdate it should be based on selection.

Is it possible to achieve?

Pls help

[Anonymous]

Hi try this,

Sum({<Date = {'>=$(=monthstart(max(Date),-2))<=$(=Month(Date))'}>}Amount)   from last 3 months

[sunny_talwar]

May be like this:

If(Dimensionality() = 0, Sum(Amount), Sum({<Date = {'>=$(=monthstart(max(Date),-2))<=$(=max(Date))'}>}Amount))