+ Start a Discussion
dev_firedev_fire 

How to Create a single Report for different time frames.

Hello,

 

I have created a  custom object "x" with lookup relation to Account.

 

There are 2 Fields in "x" :- Order Date[Date] & Rate[Number].

 

I am trying to create a report which should have columns as shown below. Is it possible? Any help is highly appreciated.

 

Daily = Rate where Order Date = today

MTD = Rate  where order date is b/w first and last date of month.

YTD = Rate where order date is b/w first and last date of year

Account NameDailyMTDYTD