Sales ratio of product groups for each store

[#1]

Hello everyone,

I want to show sales ratio of the selected product group for each store in order to compare them.

Sales ratio=  sales of product group in the store/total sales of the store

There are a lot of types of product groups. Product groups: a,b,c,d,e,f,g,....

When i clik the one of the product groups, I want to see the sales ratio of that group of products in each store.

I couldn't fix total store sales while selecting product group.

store   names	Total sales	Group a sales	Ratio
EZM	1.885.515 TL	379.745 TL	20,14%
KCY	1.878.787 TL	370.048 TL	19,70%
KTA	1.860.449 TL	243.906 TL	13,11%
UMR	1.622.075 TL	213.078 TL	13,14%
SRD	1.538.014 TL	212.894 TL	13,84%
BBR	1.519.321 TL	168.514 TL	11,09%
MSK	1.484.457 TL	165.852 TL	11,17%
ERR	1.300.119 TL	162.371 TL	12,49%
FTA	1.219.798 TL	139.924 TL	11,47%
KSA	1.195.546 TL	111.287 TL	9,31%
TCR	1.148.581 TL	110.808 TL	9,65%

I tried (Price)/sum(TOTAL<Group> Price)  expression but it doesn't work. It shows sales ratio of each stores.

Could you help me?

[#2]

Hi,

look on example.

You may use expression like:

sum(val)/sum({<group=>}val)

regards

Darek

[#3]

Thanks Dariusz.

Can I use  this expression "sum({<group=>}val)" for more than one dimension?

For example, we have parent groups and child groups. How can I calculate total sales for child group and parent group? I want that total sales for stores dont change even if i select one of the parent groups or child groups.