Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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?
try putting the expression as an expression in a listbox
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.