Displaying

Hi there

I got the following returned simple dataset as follow:






Code Snippet

ReportViewType; Category; Name; Units; Price;
LIST_VIEW; FRUITS; Apple; 1; $10
LIST_VIEW; FRUITS; Banana; 2; $11
LIST_VIEW; CARS; Corolla; 8; $100
LIST_VIEW; CARS; BMW; 10; $200

I've managed to grouped by Category field nicely and added extra calculated column for handling to total plus as well as Total for each group plus added a new row for TOTAL in the TABLE and returned as follow:





Code Snippet

FRUITS
Apple; 1; $10; $10
Banana; 2; $11; $22
TOTAL FRUITS; $32

CARS
Corolla; 8; $100; $800
BMW; 10; $200; $2000
TOTAL CARS: $3000


TOTAL: $3032

Now I want to put another extra row underneath TOTAL for handling the calculated but the business rule is only for displaying from the first group for instance:






Code Snippet

TOTAL: $3032



Calculated Average per fruits: $1010.67 ($3032 / 3 UNITS).

3 UNITS is coming from Units for Apple and Banana.

I don't know if I can do this cause i did try to use





Code Snippet

=SUM(IIF(Fields!Category.value = "FRUITS", Fields!Units.Value, 0))
But it's successfully compiled but the report result error (#Error) on that field only. Any ideas?

I thought a simple like this can be handled quite easily instead of creating a new report view type in the the same dataset to handle this particular extra line.

Waiting your comment/feedback.