AnsweredAssumed Answered

Summary in a Portal with multiple Records

Question asked by TracyBogans on May 24, 2012
Latest reply on May 29, 2012 by philmodjunk

Title

Summary in a Portal with multiple Records

Post

I have one table that contains all billing records. ( Sample Below Table 1).. Note I have other tables that have relationship between them to include Table1 ... Example  I have a Vendor Table , Account Number Table

Vendor Table & Table#1  uses VendorName as Relationship

Account Table & Table #1  Uses AccountNumber as relationship

 

Table#1

VendorMonth of ServicesAmountAcct Number

Sprint                        Feb 2012                        $3                        111
Sprint                        Feb 2012                        $4                        222
Sprint                        Feb 2012                        $3                        333
Sprint                        Mar 2012                        $4                        111
Sprint                        Mar 2012                        $2                        222
Sprint                        Mar 2012                        $3                        333
Sprint                        Apr 2012                        $4                        111
Sprint                        Apr 2012                        $4                        222
Sprint                        Apr 2012                        $4                        333

 MCI                        Feb 2012                        $3                        102

MCI                        Feb 2012                        $4                        202
MCI                        Feb 2012                        $3                        303
MCI                        Mar 2012                        $4                        101
MCI                        Mar 2012                        $2                        202
MCI                        Mar 2012                        $3                        303
MCI                        Apr 2012                        $4                        101
MCI                        Apr 2012                        $4                        202
MCI                        Apr 2012                        $4                        303

 PPE                        Feb 2012                        $3                        120

PPE                        Feb 2012                        $4                        220
PPE                        Feb 2012                        $3                        330
PPE                        Mar 2012                        $4                        110
PPE                        Mar 2012                        $2                        220
PPE                        Mar 2012                        $3                        330
PPE                        Apr 2012                        $4                        110
PPE                        Apr 2012                        $4                        220
PPE                        Apr 2012                        $4                        330
 

 

 

In the Portal I would like to see the following:

 

Sprint                   Feb 2012                        $10  ( This is the total for Sprint Feb 2012 All accounts)

Sprint                   Mar 2012                        $9

Sprint                   Apr 2012                        $16

MCI                       Feb 2012                        $10

MCI                       Mar 2012                        $9

MCI                       Apr 2012                        $16

PPEFeb 2012$10

PPEMar 2012$9

PPEApr 2012$16

Outcomes