Dynamic table based on user selection

[Anonymous]

Hello,

I have multiple expressions.

• No of Orders
• Total quantity
• Total Order Amount
• Avg Quantity
• Avg Order Amount

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 ?

Thank you,

[sunny_talwar]

Check this link may be:

Customizable Straight Table

[johnw]

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.