Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
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)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.1k users

Browse Categories

...