5

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.

enter image description here

Is there a solution to remove this aggregation in tableau ?

Thanks

Gowtham Ramamoorthy
  • 830
  • 1
  • 11
  • 31

1 Answers1

6

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:

enter image description here

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

enter image description here

e h
  • 7,039
  • 6
  • 36
  • 53