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

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

Cross tab Sort Oder

Hi there,

I have a cross tab in a report that has the following rows:

Event Year
Event group
Event Name

I'd like to sort by event date after the event group field but do not want to add the field to the output of the report.  Does anyone have any ideas on how to accomplish this?

Thanks in advance,
1 Solution
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Set level-3 rows in the Crosstab to a formula that combines Event Date & Name.  
Select that level-3 row formula in the CrossTab expert, click on Group Options... button, select the Option tab, and turn on the checkbox to customize the 'Group Name Field'. Select the event name field to act the group name field.
rporter45Author Commented:
Works perfectly! Thank you!

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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