How to...

[David_Skov]

add up data so that I handle categories instead of single goods?

I have my database with retailname, storeID, SKU-ID, SKU-name, Turnover, margin etc.

I would like to make categories so that I can add together income from all goods in same category. If I have:

Toothpaste Whitening and Toothpaste Flour how do I gather them into My category Toothpaste.

Each good has uniqe ID

In advance tx ray:

 

[bat17]

in the table that describes the goods you will need to add a field to hold the category, you may want to make this a look up from a category table if you want to be able to store details about the category and it will make it easy for you to limit the number of categories that can be used.

once you have the category info added you can group on that rather than the Goods ID.

HTH

Peter

 

[David_Skov]

I don't get that

The reason is that the names might change but the EAN or produktID code do not change.

Anyway, you say I can make it a look up? how?

in the table that describes the goods you will need to add a field to hold the category, you may want to make this a look up from a category table if you want to be able to store details about the category and it will make it easy for you to limit the number of categories that can be used.

once you have the category info added you can group on that rather than the Goods ID.

HTH

Peter

 

[David_Skov]

Ok now I made my categories and it seems to work fine, but what formula in my query to use if I wants to sum income/turnover from each category. I have a coloum in my query which marks/shows each SKUs relation to a category.

Is it DSum or?

 

[Norie]

You just need to use grouping.

Create a new query add your table, add the category field, income field and turnover field.

Right click and select totals (or go View>Totals. From the dropdown which should appear change Group to Sum for income and turnover.

Now run your query.