Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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.