Current date Sales only in a straight chart

[geogou1973]

Hello,

I have in the inline table the fields DATE, STORE, SALES,

also i have created a variable with the current date.

How can i have in a straight chart the sales of the store only

for the current date without selecting from the listbox.

Thank you in advance

[v_iyyappan · Accepted solution]

Hi,

Try like this,

Created the variable :

vCurrentDate = Date(Today());

=Sum({<Date={'$(=vCurrentDate)'}>}Sales)

Regards,

[tresesco]

Take STORE as dimension, write expression like:

=Sum(If(Date=Today(), SALES))                               // you might have to be careful about the date format.

[geogou1973]

It works.

Thank you very much.