AnsweredAssumed Answered

Total of checkbox fields

Question asked by vincer on Aug 19, 2017
Latest reply on Aug 21, 2017 by vincer

Hello,

it is probably a simple question but I am not able to find the answer.

 

My Table has the following fields:

PRODUCTS_CATEGORY (text), for example “sport clothes”, or formal dress", or "casual dress", etc

PRODUCTS_JACKETS (text checkbox) with 6 colors (black, white, red, light grey, dark grey, beige)

PRODUCTS_SHIRTS (text checkbox) with 6  colors (black, white, red, light grey, dark grey, beige)

PRODUCTS_PANTS (text checkbox) with 6  colors (black, white, red, light grey, dark grey, beige)

I used the checkbox because each Product (jacket, Shirt, Pants) can be of more than one color.

 

My question:

I need to have 3 fields summarising how many of each colors there are for Jackets, for Shirts and for Pants for each PRODUCTS_CATEGORY.

 

Many thanks for your kind help,

Vince

Outcomes