Exporting aggr table?

[#1]

I am attempting to trouble shoot a problem and would like to see the temporary table that my aggr is creating. Is it possible to display or export this?

[morganaaron]

Not as far as I know, but it should be achievable by correlating your output from the aggr() statement with a normal table chart containing the same dimensions/expression that you've got in your statement, if that's a possibility?

If you wrap your aggr() statement with a concat() function (and add a delimiter) it should show you what it's output is - then recreate your statement as a table containing your expression and whatever fields you're aggregating over as dimensions?

[giakoum]

try putting the expression as an expression in a listbox

[isorinrusu]

Following what Aaron says, the following expression,

aggr(sum(Sales),Vendor)

can be viewed in a normal table with dimension Vendor and sum(Sales) as its expression.

You can do more complex things based on this.

Hope it's helpful,

Sorin.