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])

[rubenmarin]

Hi kumar,  maybe with:

Sum({<Region>} sales)

[Anil_Babu_Samineni]

Perhaps this?

Sum(TOTAL <[Store Region]> {<[Store ID]>} sales)

[rkpatelqlikview]

Hi Ruben,

No. Value is changing based on the store ID.

[rkpatelqlikview]

Hi Anil,

I applied this one also. But its showing all the regions sales but i need one region sales  that ID in that region.

After put this expression.

Sum(TOTAL <[Store Region]> {<[Store ID]>} sales)

When i entered the Store ID text object is showing all the sales of all the regions. Its not changing.

[Anil_Babu_Samineni]

Do you mean this? If none of the works, Please post sample

If([Store ID] = SubStringCount([Store ID], [Store Region]), Alt(Sum(TOTAL <[Store Region]> {<[Store ID]>} sales),Avg(0))

[rkpatelqlikview]

Sure. I will provide sample.

[rkpatelqlikview]

Hi Anil,

Please find the attached.

[sunny_talwar · Accepted solution]

Try this

=Sum({<[Store Regions] = p([Store Regions]), [Store ID]>}Sales)

[Anil_Babu_Samineni]

PFA