How can we achieve this report

[EArumugam]

hi all,,

how to create the report as below. prod type , subtype and sales come from same table.
but i want to split A & B into one and make subtotal and C as seperate

Prod Type    | Sub Type | Sales
A        A1      10
        A2          20
        A3      30
TOTAL A                      60
B        B1        5
        B2            4
        B3            3
TOTAL B         12
      
Net Sales(A+B)      72
      
C        c1        1
        c2        2
        c3        3
Total C           6

Gross Sales (Net Sales(A+B)-Total C)   66


please let me know if the question is not clear

[MFGF]

Try adding a calculation in a list column along the lines of:

if([Prod Type] in ('A', 'B')) then ('A+B') else ('C')

Group on this list column first, and you should get a result resembling your requirement.

Regards,

MF.