Help! Graphical values ​​to the Previous Month

[#1]

How do I bring in a graph with the dimension month and the expression Sum ([amount billed]) where the value to the previous month?

May Today we want him to bring me the value only until the end of April

Any Idea?

Att,

João Henrique

[#2]

Hi try this

=sum({<[date]={">=$(=MonthStart(date),-1))<=$(=MonthEnd(date),-1))"},Year=,Month=,Quarter=>}amountbilled)

I hope this is helpfull to you

Regards

Bharathi

[juleshartley · Accepted solution]

I would make a variable vLastMonth =Date(MonthsEnd(1,Now(),-1),'DD/MM/YYYY')

Then use set analysis similar to Bharathi above:

=sum({$

<

//Remove any date selections if they are affecting your data set

Year=,

Month=,

Quarter=,

//apply the filter to your date field

[date]={"<=$(=vLastMonth )"}

>

}amountbilled)

[#4]

Thank you! in a few days I will have to test!

[#5]

Thank you!