How to sum from specific criteria

[Anonymous]

Hi, 

I'm new to this power BI and need your help

So I have this data

Product	Revenue
A	1000
B	4000
C	5000
D	3000
Subtotal 1	13000
B	500
C	400
F	1200
G	3000
H	3000
Subtotal 2	8100
Total	21100

How can I get the sum of revenue but only from the data above subtotal 1? because I have also the same product above subtotal 1 and below subtotal 1 like B & C.

Thank you

[lbendlin]

You need to add (as a minimum) another column to your data that identifies the subgroup.  As it is your data is not usable in Power BI (Power BI does not guarantee sort order!).  Or maybe add an index column.