Dynamic Statistical Date

[katetsan]

Hi Expert,

Here's my question and if I explain not properly, please don't hesitate to indicate me.

I have Account Receivable data set, which has several fields. Two of them called "Accounting Date" and "Clearing Date".

I would like to create a bar chart, the x axis would be Statistical Year Month, which is not included in the AR data set.

And the value should be filter and accumulated by Statistical Year Month, for example,

If the statistical year month is 2019/3 , and the formula  should be "Accounting Date"<= 2019/3/31 and "Clearing Date">2019/3/31.

However, I've tried below expression in bar chart and it doesn't work well. Is there anyone could give me some instruction?

Expression:

sum({<[Accounting Date]={"<=Date"}, [Clearing Date]={">Date"}>}AR balance Amount)

Note:

I generate a "StatDate" table contain three fields which is Date, Year , Month for bar chart X axis (Statistical Year Month).

[JordyWegman]

Hi Kate,

I've changed the formula so you can use it with the StatDate. The Only function is used so you have to select one date!

Jordy

Climber

[katetsan]

Hi Jordy,

Thanks for your reply. 

I've tried the rangesum()+above() could solve my problem temporarily.

Really appreciate your help!