I have a excel file data attached here :
Columns are as below:
Team Rep Total Calls Total Duration Date
Where I want to output by giving an from data and to sysdate(today's date)
So the report should give me Like as below:
Team ,Rep,Total Calls ,Total Duration ,WeeklyAverageCalls,Weekly
Call and lastly YearlyAvgDuration .
Should have in a single row.
Is there any way where I can pass the dates as a parameter so that It will calculate accordingly.