Create a calculated field in a way to calculate filtered column values

[RR_13]

Hey All,

I am struggling to find out a way to solve the below problem.

I have the below data:

id	mileage	mode
220123	6400	manual
220123	6400	manual
220123	6400	automatic
220123	6400	automatic
220123	6400	automatic
220123	6400	automatic
220123	6400	automatic
220123	6400	automatic
220123	6400	automatic
220123	6400	automatic
220123	6400	manual
220123	6400	manual
220123	6400	manual
220123	6400	manual
220123	6400	manual
220123	6400	manual
220123	6400	automatic
220123	6401	automatic
220123	6401	automatic
220123	6401	automatic
220123	6402	automatic
220123	6402	automatic
220123	6403	manual

Problem : How can we find out that how many miles a car has drove in automatic and manual mode. 

[Arul]

@RR_13 ,

Just drag and drop Mileage and Mode columns in the table visual and you can see the result. If not this you wanted please let me know.

Thanks,

Arul