How to avoid aggregating measure values in a table
I am trying to get and parse records from SQL server. Whenever I drag a dimension field into a row field, it will automatically aggregate in the table.
I do not want this aggregation to be done as my values are meaningless when they become aggregated.
Is there a solution to remove this aggregation on the table?
thank
+3
source to share
1 answer
Yes, you can avoid aggregating values. However, your problem is not that you are aggregating your values, your problem is that you treat dimensions as measures.
To fix this, you can convert Year
from dimension to dimension:
Of course, if you want to disaggregate these measures, you can always do this:
+5
source to share