Aggr an Aggr function?

[hobanwashburne]

I have the following Aggr function that operates as it should

fabs( StdMdl *  Max (TOTAL Aggr (Sum (  {< GapAnalysisFlag = {1} >}  [Net Sales]) / StdMdl  , [Forecast Product Line DESC]))) - Sum( {< GapAnalysisFlag = {1} >}  [Net Sales])

So, when a customer is selected the chart displays:           

                      ProdLineA   ProdLineB   ProdLineC    ProdLineD

CustomerA   $0                 $2,350         $5,103          $4,987

However, when the selection is more broad the data changes. For example when a Group that consists of Customers A & B (and others) the data changes to the following           

                     ProdLineA        ProdLineB         ProdLineC      ProdLineD

CustomerA   $101,000,700   $28,484,709      $5,103,864     $4,987,849

CustomerB   $101,000,600   $26,156,123      $26,100,800   $48,456,123

CustomerC...

What I would like to display is:            

                      ProdLineA         ProdLineB     ProdLineC   ProdLineD

CustomerA    $0                      $2,350           $5,103        $4,987

CustomerB    $6,156               $0                  $3,120        $6,800

CustomerC ...

[MarcoWedel]

can you please post some test data?

thanks

regards

Marco

[hobanwashburne]

see attached