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 answer
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.
