Pie Chart Dimension filter

[Anonymous]

Hi

I have a pie chart that shows the staff count for staff starting with the organisation.  This has a dimension is by 'Division'.

I only want to show the data within the chart for any staff starting after Jan 2013 and earlier than today (planned start date).

As I do not have the date dimension in my pie chart, how do I do this?

Thanks

Phil

[Nicole-Smith]

In your expression, you can use set analysis that looks like the following:

count({<[Start Date]={'>=$(=MakeDate(2013,1,1))<=$(=today())'}>}[Staff Field])

[bruno_m_santos]

You must use set Analysis in your expression, like this. I Suggest use variables.

Count($<Date={">=$(=Date(vDateStartP1,'DD-MM-YYYY'))<=$(=Date(vDateEndP1,'DD-MM-YYYY'))"} > Staff)

Thanks

Bruno