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 don't want this aggregation to be done since my values don't make sense when it gets aggregated

Is there a solution to remove this aggregation in tableau?

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.

• In order to fix this you can convert Year from a measure to a dimension:

• if you want to disaggregate the measures then you can always do that too: