Based on formula field can i get the quarters divided in a fiscal year
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.
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 .
The Table look like this :
ProductName Quantity Amount Q1 Q2 Q3 Q4 Total
BXRC-25e4000-F-04 100 5000 100,5000
BXRC-25e4000-F-04 200 3000 200,3000
But I'm looking for a table like Summary Report like this :
ProductName Quantity Amount Q1 Q2 Q3 Q4 Total
BXRC-25e4000-F-04 300 8000 300,8000
Anu help is very much appreciated
답변 3개
Where are you trying to do this? within a Master record like the Opportunity, or in a Report or Dashboard?
