[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 209
  • Last Modified:

Conditional Group by.. Is it Possible?

Hi I have a report I want to group by two different  fields (one or the other) and Im using a parameter.. For example lets say the user picks State, then grouping would pick and do a total by state. Otherwise the user picks Country and it does a grouping and  total by country..

So currently it will group by country but not by states.. Is there anyway to do either or? Like a Conditional grouping so to speak?? thanks in adv.
1 Solution
Very Possible.

Create a formula called group1 - insert something similar to the following-

if {?myparameter} = "state" then {mydatabase.state} else
if {?myparameter} = "country" then {mydatabase.country} else "error"

Then just change your group to group on that formula!
shockaconAuthor Commented:
that worked! thanks

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now