Performance by Time

[surajap123]

Hi All,

I want to find out how many weeks and Total Hours booked in a specific time period(Daily,Weekly,Monthly,Quaterly,Yearly,YTD,MTD etc) by ProgramName.

I think of creating straight table to show the data but unable to get the correct result.

I am attaching the app i developed with the sourcedate. Please help !!

[surajap123]

I could able to analyze the weeks and Total Hours booked by each DATE, using pivot table.

But i want to achive this using Straight table.

Could anyone help me..