Porcentage transacctions by store

Tue, 16 Jun 2015 20:35:29 GMT

Hello

I need to create a table that show the follow:

Product	< 20%	20% - 50%	51% - 80%	> 90%
Product A	8	25	80	20
Product B	30	70	15	2
Product C	55	15	15	7
Others	45	100	25	15

In 8 stores the Product A represent less than 20% of the total store transacctions

In 70 stores the Product B represent between 20 and 50 percent of the total store transacctions

In 7 stores the Product C represent more than 90 percent of the total store transacctions

etc.

In the Database I have a Fact Table with the detailed transacctions, the fact table is like this:

Date	Store	Product	Transacction ID	Amount
15/06/2015	Store 1	Product A	00000001	$ 10.75
10/04/2015	Store 3	Product B	00000002	$ 28.35
14/03/2015	Store 2	Product A	00000003	$ 50.38
10/04/2015	Store 1	Product C	00000004	$ 45.22

Someone know how can I elaborate this kind of anlaysis

Best Regards

topic Porcentage transacctions by store in QlikView