Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I read the developer book on aggr function.
In one expression you have: max(aggr(sum(LineSalesAmount), CategoryName, ProductName))
Why do you need to dimensions (category and product) when the expression gives the same result with only product field specified?
I get the same result if I just do: max(aggr(sum(LineSalesAmount), ProductName))
Please explain.
you can get the same result but not always
i agree with Massimo. And to add one more point,in your chart if you do not have dimension category this expression holds good max(aggr(sum(LineSalesAmount), ProductName))..
But in the chart if you have dimensions both ProductName & CategoryName-- then we have to use max(aggr(sum(LineSalesAmount), CategoryName, ProductName))
because aggregate function works only when you list all the diemensions present in the chart.