Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everybody,
I am using the below fields in a Straight Table
Business Unit
Assured BA Code
Assured Name
Assured Country
Forecast New Existing Non Recurring
Forecast New Existing Recurring
Forecast New New Non Recurring
Forecast New New Recurring
Forecast Non Recurring
ForecastRATE
By using the below expression am getting the individual records.
Expression:
[Forecast New Existing Non Recurring]+[Forecast New Existing Recurring]+[Forecast New New Non Recurring]+[Forecast New New Recurring]/ForecastRATE
Now I want to group it up the values and get values quarter wise as shown in the attached file.
Could anyone please advise how to achieve this.
Thanks In Advance
Ashish
Ashish,
You don't have any date field here , you need include the same and further follow script for calculating data Q wise :
Date(Date, 'MM/DD/YYYY') as [Date Coded], | |
Monthname(Date) as Month, | |
Year(Date) as Year, | |
Quartername(Date) as Quarter, | |
'Week'&Ceil(Day(Date)/7) as Week, |
Thanks,
AS
Hi Amit,
Thanks for the reply.
I have a date field but didn't use here. Will include the field and give a try.
Thanks
Ashish
Hi Ashish,
Good , after doing this call Quarter as dimension and your expression below to see the desired result:
[Forecast New Existing Non Recurring]+[Forecast New Existing Recurring]+[Forecast New New Non Recurring]+[Forecast New New Recurring]/ForecastRATE
Hope this will help you!
Thanks,
AS