if @param = 1 then

  {table.revenueDollar}

else

  {table.revenuePercent}

 

then set the group on the formula.

 

HTH

You will have to play with this but basically Lockwelles approach is the foundation. You need to flip a value in the a formula field (if-then) but then you need to use the Insert Summary function (like a SUM) at the group customer level on that formula and use that for your TOP N sort but set the TOP N to a number higher than the largetst number of customers in your report and it will sort all.

Do each step seperate and test it (run your report) so you see what is happening.

Create a parameter ... (1 for sort by Revenue $ or 2 by Revenue%)

Now create a formula field. This part is where you will have to figure out what values to put in later. For testing/learning though just use it to flip between two easy report values...

Call the formula "Sort"...

 

If you used the @Revenue$ or @Revenue% field the @Sort willnot appear because you cannot summarize a summary.

I realize that this is what you want but you cannot do it.

I wanted you to first get proof of concept and see how it works.

Once you get it to work you only need to figure out what values to use in @Sort that will give you the same sort order (even if it is not the same values).

 

Maybe there are none and this will not work, although hopefully you can learn a new trick, but this is the only way I know of to dynamically sort groups.

 

If they are common aggregates, you can create a formula like:

if @param = 1 then //just for instance

  SUM({table.revenue}, customer group);  //for sorting by revenue

else

  SUM({table.revenue}, customer group) / SUM({table.revenue}) //percentage of a customer vs the entire report

 

 

if you want, you can drop the formula on the gf line and see if reports the correct number (this just tests that the formula is working as desired). I am assuming that there is a grouping on the customer, otherwise this may need refinement.

 

Now since you want to sort all of your group based on the formula, create a group that will be 'above' the customer grouping.  Instead of selecting a table field to group on, select the formula that you just created...The report will now sort based on the parameter.

 

HTH