Calculating the relative percentage

[m4u]

Hello Friends

I have a problem:

I would like to create a line chart, showing sales trend for a number of stores.

X-axis should show years, the Y-axis should display the store's contribution in percentage (current store sales on this year - devide in total sales for this year). Each store will appear as a line.

The problem is when I want to choose just one store. So I see 100%.

I tried different ways, Including "Set analisys","total" Keyword, But each of them creates other problems.

Does anybody have an idea for me?

Many thanks,

Shlomo

[pover]

Shlomo,

If you want to just ignore the selection of store do something like the following:

sum(Sales)/sum({$<Store=>} Total Sales)

If you want to ignore all selections include a {1}

sum(Sales)/sum({1} Total Sales)

Karl

[swuehl]

Try something like

=sum(Sales) / sum({<Store= >} total<Store> Sales)

The {<Store= >} set expression should clear your selection in Store for the denominator calculation.

Hope this helps,

Stefan