please give me answer

[#1]

how can we get number of fridays in june month

[jagan]

Hi Sravani,

While loading the data do this

Data:

Load

     *,

     WeekDay(DateFieldName) AS Day

FROM DataSource;

Now in expression use this set analysis expression

=Count({<Day={'Fri'}>} DISTINCT DateFieldName)

Hope this helps you.

Regards,

Jagan.

[nilesh_gangurde]

Please find the attachement for Solution.

-Nilesh