I need to add a table which shows either [NO of Orders, Total Qty, Total Order Amount] or [No of Orders, Avg Quantity, Avg Order Amount]. What is the best way to do it ?
If all you're doing here is selecting what kind of aggregation to do, maybe a list box for field Aggregation with values Total and Average, where you must and can only select one value. Then expressions like if([Aggregation]='Average',avg(Quantity),sum(Quantity)). There are arguably more elegant ways, like defining your expressions in script, but I can see myself just doing that simple if() and moving on if there are only a few fields and only a couple choices.
If you want more dynamic capability, stalwar1's link is very close to how I do dynamic charting.
