Forum Discussion

Mahmoud_nabir's avatar
Mahmoud_nabir
Frequent Visitor
7 years ago

calculate sum with filter between two column

i want to Column Value = (count Number of Rows in Customers Visits  where Customer VisitDay = Planned Visit[VisitDay])   filter is only between column and single value but i want to sum filtring by...
Need Help
Mahmoud_nabir's avatar
Mahmoud_nabir
Frequent Visitor
7 years ago

i have 2 Table:-

Planned Visits Details(view customer with planned visit day )

planned Visit Week (total planned visit by week day) (Visitday Column is Text )

 

i want to count the number of visits by week day

 

 

Planned Visit Week 

Visit Day            Planned_visit

Friday                  = count (customerId) where planned Visit Week[VisitDay]= planned visit Week[Visitday]

Saturday             = count (customerId) where planned Visit Week[VisitDay]= planned visit Week[Visitday]

 

Planned Visits DetailsPlanned Visits Details

 

Planned Visit Week