Calculating number of people whose status changed in a Week Number

[android1]

Hi,

I have a table called vwStaffAudit. It contains the names of all active & inactive staff.

A staff is active if column 'Active' (text format) is Y.

A staff is inactive when column 'Active' is changed from a Y to N.

When a staff is changed from a Y to N, an audit date is added to column AuditDate.

I want to select a week number (in a slicer) that shows the number of staff made inactive in that week.

How would I go about this?

[Greg_Deckler]

I would probably do somethig like create a column in your table based upon:

WeekNo = WEEKNUM([AuditDate])

Then you could just have a slicer based upon this column and a slicer for the Y/N field. You might need a Year slicer as well.