function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ 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