How Can I Display Individual values for a Measure field Instead of a Sum?

Question

The field Total Charge Amount Contains multiple values. When I add it to a table visualization, I expect to see a list of each individual amount in that field. However, instead, I'm getting the sum of all values in the Total Charge Amount field.

How Can I Display Individual Amounts(Values)  for Total Charge Amount Instead of a Sum? Do I need to do something at the Dataset level?

Bret Grinslade - Oracle Analytics-Oracle · Answer

You can also use the "treat as attribute" option if you only want the details for one chart and "sum" everywhere else.  In OAC, measures default to a calculation.  Some tools always start as "attribute" and then only aggregation per viz.

Chere-Oracle · Answer

Hi @Lokesh Obhilineni-Oracle , If you do not intend to use this column as a measure, yes, you should change it in the dataset — change it from a measure to an attribute.