topic Re: Pivot table giving null values if i add non aggregated measure such as Amount instead Sum(Amount) in App Development

Pivot table giving null values if i add non aggregated measure such as Amount instead Sum(Amount)

vish123 — Thu, 30 Jun 2022 08:29:28 GMT

Hi Team,

When i add non aggregated field such as Amount instead of sum(Amount) it is giving me null value. Please suggest a way to resolve this issue.

Thanks,

Vish123

Re: Pivot table giving null values if i add non aggregated measure such as Amount instead Sum(Amount)

Or — Thu, 30 Jun 2022 08:31:37 GMT

You've already got the answer - use an aggregated measure which is able to return a value for your combination of dimensions. Using a non-aggregated measure is the same as using Only(Measure), so this will only work if the combination of dimensions returns a single value of Measure.

Re: Pivot table giving null values if i add non aggregated measure such as Amount instead Sum(Amount)

vish123 — Thu, 30 Jun 2022 08:49:15 GMT

Hi Or,

I have tried like this but did not work using Aggr function.

aggr(Amount, CID) .... CID is the dimension that i have used in pivot

also tried aggr(sum(Amount), CID) as well but dint work... Please suggest.

Re: Pivot table giving null values if i add non aggregated measure such as Amount instead Sum(Amount)

Or — Thu, 30 Jun 2022 09:09:16 GMT

I'm not sure what suggestion you're looking for. You haven't explained what your data structure is, what your pivot behaves like, or what you're trying to achieve.