How to get only total region sales even selecting the store ID

[rkpatelqlikview]

Hi All,

Please let me know how to get region wise total sales even you selecting the store ID.

Store ID is the only Input. It will show the store region along with that i need all the stores sales in that region.

It should associate only with dates not with ID's.

what is the calculation? How to use set analysis?

I used to work with Only function.

=sum({<only(total Region)>}[sales])

[rkpatelqlikview]

Thanks for your help sunny.

Its Correct one.

[rkpatelqlikview]

Thanks for your quick response Anil and thanks for your Help.

Its taking all region values again. This is also one good scenario  which is very useful when we want all the region sales.

Thanks once again.