Avoiding SumOf prefix

[d000075]

I wish to avoid the SumOf, AvgOf prefix in queries. I am aware that I can write sales:sales but in a query with 50 columns that is somewhat annoying.

Any help would be appreciated.

 

[boblarson]

In your query, give the column a name. You can't use the field name but you can just say this:

For example if you have a field named OrderTotal you would get SumOfOrderTotal if it was an aggregate using the sum. To get around that in your query do -

Order Total:OrderTotal

Notice that I gave the name Order Total with a space, but the field name was without a space. I could have done this too

My Order Total:OrderTotal