Hello,

I've working on this report for few days and I am still stuck on this grouping problem that I have and I really would hope somebody can help me solve this problem.

My questions is, how can I design my report so that there are two big sections, the first section has 2 groups that are all about face items and any items other than face item would go to other section.  it looks something like below:

Face - Oil type
 
item               qty   unit price
eyeliner           5         $10
lip stick            4         $4
Total                9         $14

powder            2         $10
cream              2          $30
Total                3          $40

Face - dry type
item               qty   unit price
eyeliner           3         $10
lip stick            2         $4
Total                5         $14

powder            1         $10
cream              5          $30
Total                6          $40
 
other (the rest items that are not facial products)
item               qty   unit price
hand cream     1           $5
Shampoo         2           $6
Total                3           $11

Please advise how to make two big sections and the first section contain groups and the section section is the rest items. 

Thanks!

Thanks, but where do I put that formula? Sorry I am very new here...

in the field explorer you create a formula field and use kostya's code.

Edited by DBlank - 26 Aug 2014 at 8:11am

Thanks! I finally got the layout I wanted. How can I do totals within each section? And Where should the calculation go? Thanks! Below is the sample:

Face - Oil type

item              qty   unit price
eyeliner           5        $10
lip stick           4        $4
Total              9        $14

powder             1        $10
cream              2        $20
Total               3        $30

Thanks DBlank. But what I mean is how do I break the item into two separate sections and do a total per each section? ie: for Face-oil type group has two sections, and I need to total each section.

Thanks!!