Is conditional grouping possible?

[NipsMG]

Is conditional grouping possible?

Basically, I've got a formula that sets a flag one way or the other.

If the flag is set one way, I want to group by location ONLY. If not, I want to sort by Item, then by location.

The only way I can figure to do this is

Conditional group by Item
Static location group.



Is this possible?

Thanks in advance!

 

[synapsevampire]

A Group is not the same as a SORT, so I'll assume that you mean that there would not be a grouping in one of the instances.

Create this formula to group by:

if {?MyFlag} = "Location" then
{table.location} else
""

Use this field as your sort field:

if {?MyFlag} = "Location" then
""
else
{table.item & " - " & {table.location}

If you meant to use the term Group when you stated Sort, then just alter the first formula to:

if {?MyFlag} = "Location" then
{table.location} else
{table.item & " - " & {table.location}

-k