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

Lokesh Obhilineni-Oracle

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?

Chere-Oracle

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.

Bret Grinslade - Oracle Analytics-Oracle

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.