Set Analysis Problem

[#1]

Hi everyone,

I am using the below Expression in order to get data from database start date to till Previous Month end .

=Sum({$<M=,Y=,Month = {"<=$(=MonthEnd(AddMonths(Max(Month),-1)))"}>}Amount)

It is Working fine with Text box Object,but when i use the same expression in Chart object.It is just giving Current month sum.

Dimension is M.

PFA,

please suggest me .Little urgent.

[#2 · Accepted solution]

Hi!

I guess you want to show something like this:

You can make it with the "Full accumulation" option in the properties (this image is from google, ignore the red circle):

I hope it helped!

[#3]

Not sure how your app looks, but you need probably to use an ALL or a TOTAL.

All calculations is done in a chart in regards to the dimension unless you specify it should go outside of that limitation

=Sum(ALL {$<M=,Y=,Month = {"<=$(=MonthEnd(AddMonths(Max(Month),-1)))"}>}Amount)

Cheers,

Martin