0 votes
1 view
in BI by (17.6k points)

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

enter image description here

Is there a solution to remove this aggregation in tableau?

1 Answer

0 votes
by (47.2k points)
  • 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:

enter image description here

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

enter image description here

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Jul 29, 2019 in BI by Ashok (47.2k points)
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...