How to avoid aggregation of measure values in tableau

Question

I'm trying to retrieve and analyze records from SQL server. Whenever I drag the measure values to rows field it gets auto aggregating itself in tableau.

I dont want this aggregation to be done since my values doesn't make sense when it gets agregated.

Is there a solution to remove this aggregation in tableau ?

Thanks

Answer 1

Yes, you can avoid aggregating values. However, your problem isn't that you are aggregating your values, your problem is that you are treating dimensions as measures.

To fix this you can convert Year from a measure to a dimension:

Of course, if you want to disaggregate the measures then you can always do that too: