Showing Groups Horizontally

[strom99]

Is it possible to show the groups across rather than down? I have created 5 custom groups based on a product code and am trying to show what each of the groups daily sales are. I have a field called BILL_RUN_DATE which calculates the INV_GROSS_AMT every day and I need to subtotal this amount for each of the 5 groups. Using CR8.

THANKS

 

[IdoMillet]

You have several choices:

1. Cross-Tab
2. Five Conditional Running Totals (specify group-field = group1, 2, 3, 4, or 5)
3. Simple Conditional Formulas (IF {It's a record from group1} then Value Else 0)
that you would then total

hth,
- Ido