Combining/Grouping Question

[waugh]

And another question I have:

A retail store has 5000 SKU's. Within all those SKU's are items that are similar, for example Pepsi/Coke/Sprite may all be represented as soda.

Example:
SKU 0001 Soda Pepsi Qty sold 150
SKU 0002 Soda Coke Qty sold 250
SKU 0003 Soda Sprite Qty sold 350

How can I write a formula to do display something like the following?

Soda Qty sold 750 (which is the sum of the above items)

Thanks in advance for your help!

 

[Naith]

For both your question, right click the field, and use the Summary options.

In this instance, reset the summary on Change of Group.

To count items, insert a condition of {value} >= 6.

Naith

 

[waugh]

This is a formula field. I don't have Summary options when right clicking.

 

[dgillz]

Please post your formula. Then we can see why you do not hve the summary options. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[waugh]

I don't have a formula yet because I don't know how to accomplish this. When the previous post asked me to choose summary options after right clicking the formula field, I right click "a different" formula field so I could investigate what summary options do.

Can a formula be written to combine defined items or sku's as one item? As with the example above, I don't want to report sales of pepsi, coke, sprite seperately. I want to report them as a generic item called soda.

 

[dgillz]

You said "this is a formula field, so I do not have summary options". Most formulas do have summary options, that is why I asked you to post the formula.

If the field you are right clicking is a formula field, you will be able to copy it. Just right click on it and select edit, and copy and paste the formula to this thread.

Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[kenhamady]

Write a formula like:

If "Soda" in {NameField} then "Soda" else
If "Chips" in {NameField} then "Chips" else ...

... "Other"

Group on this field, and do a subtotal of the quantity for each group. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com