How to show result for selection in multi dimension

[kennethand]

I need some input/help here.

I've made this expression to meassure the total amount used in different supermarkets/store. In my data every respondent has answered the total amount (called amount) used per month and then distributed 100% (called Share) to different supermarkets (called Store). They also have a weight which has been implemented in the expression:

=sum(amount*weight*([Share]/100)) / sum(total{ <Store={"*"}>} [weight])

The expression gives the weighted amount per store in a chart like this:

So far so good.

But when I choose any supermarket (let's take ALDI as an example) as a filter I only see ALDI (92 danish kroner).

I really like to see the not only the result for ALDI but the tThe total amount across every supermarket (but only for the ALDI-customer as I choosed ALDI in my filter).

ALDI is just an example. I need to have an expression which can handle any  Supermarket-filtering.

[Anil_Babu_Samineni]

I feel "Super market" is the field in your database as 

sum({<Store=>} (amount*weight*([Share]/100))) / sum(total{ <Store={"*"}>} [weight])

[kennethand]

---

@Anil_Babu_Samineni wrote:

I feel "Super market" is the field in your database as 

sum({<Store=>} (amount*weight*([Share]/100))) / sum(total{ <Store={"*"}>} [weight])

---

Thanks for your suggestion. Unfortunately it doesn't have any effect.