I like to  create report of etl process. In that the report is devided in following calculated fields,

Today

Yesterday

Last 7 days.

Last Month

quarter

Last year

Theses calculated fields i required.

So please provide me the formulas on based on it.

And the problem is I have to show count of the measures filed you can refer a attached excel file for it, but how it could be possible for same formula for multiple measures?

And may i want unchecked the Analysis>aggregate function.??

I have to show report like attached excel file.

Plz help!!