Count Changing Status

[ch_riadh]

Sales_Table:

SalesID,

Date,

Status (Sold, invoiced, delivered).

I want to know how many SalesID changed from sold to delivered in a specific period.

Thanks

[luke1986]

Hello Riadh,

Use this Expression  as a Formula in a Chart

=count({<SalesID=p({<Status = {'Sold'}>}),Status = {"delivered"}>}distinct SalesID)

That should do the job.

Lukas

[ch_riadh]

it works fine, but i want to use the date,

For exemple i need to display the change in oct, then decembre.
How can define the Date in that expression.