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

[vish123]

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

[Or]

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.

[vish123]

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.

[Or]

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.