Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Hi try this
=sum({<[date]={">=$(=MonthStart(date),-1))<=$(=MonthEnd(date),-1))"},Year=,Month=,Quarter=>}amountbilled)
I hope this is helpfull to you
Regards
Bharathi
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)
Thank you! in a few days I will have to test!
Thank you!