weekdays of a date

[#1]

i have a date column which gives every possible transaction date which is pretty much every day as i do have weekend days(saturday and sunday). The issue is when i show the count(transactions) i want to show the saturday and sundays in fridays count which really is the friday's count is Friday+saturday+sunday together as but show as friday's count. But i want this only friday where rest of the days will stay as is.

How can i show the 'Sat' and 'Sun' as fridays count?

[#2]

or

==> First count weekday(Date)  ... This will return 1,2,3,4,5,6,7

==> Then  use Mapping table for WeekDayname

mapWeekDay:

Mapping Load * Inline [

weekday, Weekdayname

1          ,  Mon

2          ,  Tus

3          ,  Wed

4          ,  Thu

5          ,  Fri

6          ,  Fri

7          ,  Fri ];

Apply above mapping table on calculated field in first step.

[#3]

it was helpful thanks mrdaan.