Multiple Line Summaries | Infragistics Forums

State See Verified Answer
Replies 8 replies
Subscribers 7 subscribers
Views 1314866 views
Users 0 members are here

UltraGrid

190

Multiple Line Summaries

Jeff posted over 16 years ago

I am coding a business forecast. Several columns will have summaries (Price, Qtr 1, Qtr 2, Qtr 3, Qtr 4, Fiscal Year, etc).

I need 8 separate summary lines to be positioned at the bottom of the grid.

Total (for the above columns)
Booked (for the above columns with a Booked Status)
PO Received (for the above columns with a PO Received Status)
Committed (for the above columns with a Committed Status)
etc..

I cannot group the grid rows by status.

Your great advice is appreciated.

Thanks!

3186

Offline Nick Smith posted over 16 years ago in reply to Jeff

Looks like you might want to add a summary of type custom for each of those. Write a routine that sums only the numbers for a particular status. Believe there is an example of a custom summary in the help but it may be in a KB article.

Nick
Cancel
Reply

Cancel

190

Jeff posted over 16 years ago in reply to Mike Saltzman

Mike,

Here is a sample:

Order ID	Customer	Product	Status	Price	2008 Q3	2008 Q4	2009 Q1	2009 Q2	Total
1	Cust AAA	Prod 1		4,600	4,600				4,600
2	Cust BBB	Prod 2	B	500	500				500
3	Cust BBB	Prod 3	C	500	500				500
4	Cust LLL	Prod 3	C	1,500		1,500			1,500
5	Cust LLL	Prod 1	C	4,000		4,000			4,000
6	Cust MMM	Prod 3		3,200		3,200			3,200
7	Cust XXX	Prod 4	PO	4,000		4,000			4,000
8	Cust ZZZ	Prod 2		2,667			2,667		2,667
9	Cust ZZZ	Prod 4		1,663			1,663		1,663
10	Cust ZZZ	Prod 1		1,450			1,450		1,450
11	Cust MMM	Prod 4	C	3,200				3,200	3,200
12	Cust ZZZ	Prod 3		1,315				1,315	1,315
13	Cust MMM	Prod 2	C	2,000				2,000	2,000
	Total				5,600	12,700	5,780	6,515	30,595
	Booked				500	0	0	0	500
	PO				500	4,000	0	0	4,000
	Committed				0	5,500	0	5,200	10,700
					0	3,200	5,780	1,315	14,895
	Other				0	0	0	0	0

As you can see, I need multiple summary lines.

Is there a footer object that can achieve this?

469350

Offline Mike Saltzman posted over 16 years ago

Hi Jeff,
I don't understand what you are asking. Can you be more specific? Which part of this is giving you trouble?
Cancel
Reply

Cancel