Problem with total amounts displaying when selecting all customers

[Manu Lo]

Hello everyone,

There an issue I can't figure out.

When I filtering data on one store, I can see the correct figures but when I select all stores, they all show the same total amounts for all stores.

I am using data from two separate data tables.

Does someone have a clue of why it won't show the individual figures per store (but works when only one store is selected)

PS: I have attached a screenshot

Edit: misspelling correction

Edit 2: I just wanted to say that I eventually found the issue which was a relationship missing. between the two datatable at the store level. Thanks!

[Shashank Gurnalkar]

It's difficult to analyze with just the screenshot values. If you can share your sample DXP file with data embedded, I can take a look. 

[Khushboo Rabadia]

You must have usedover all stores in custom expression due towhich it is showing same value across all stores. You will need to form over expression in different way so it works with filters.

As directed by Shashank, if you can provide sample dxp we can look into.