
1) To Add Same Product Name ,With Quantity and Amount for Every Quarter.
2)To Achieve the Subtotals and Grandtotals for the Quantity and Amount .
For Example :Here the Product Name as "BXRC-25e4000-F-04" appears twice in a Quarter for the months Jan and Feb.Now the Quantity & Amount Should get Added displayed at one place and the product name should get appeared only once.
Can i achieve using formula field to split the fiscal year into 4 quarters as
Quarter 1=Sum of (JAN+FEB+MAR)
Quarter 2=Sum of (APR+MAY+JUN)
Quarter 3=Sum of (JUL+AUG+SEP)
Quarter 1=Sum of (OCT+NOV+DEC)
with years from past ,present and future (2013,2014,2015,2016,2017 etc)
Apart from this im looking for the o/p as :PFA Screen shot
Any Suggestion Plz.Any help is very much appreicated.
답변 1개
This Answers Community is focused on configuration and design questions. Programmatic questions are best submitted to the developer forums at https://developer.salesforce.com where the forums and participants are geared toward programming troubleshooting and support.