Joined: 23 Mar 2009
Location: United States
Online Status: Offline
Posts: 6
Topic: Grouping Posted: 25 Sep 2009 at 1:32pm
I have a report that groups by vendor. Now I want to put the vendor payments into two groups: one that contains all payments under $25,000 and one that have payment $25000 and over. I want it to kind of look like this:
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 25 Sep 2009 at 2:16pm
Create a formula field to evaluate the amount and then group on the formula as group 2. Do a sum of the amount field at group footer 2. YOu can hide the group header 2 field.
if {table.amount} <25000 then 'Under 25' else '25 and over'
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
