Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
Try this
=Sum({<[Store Regions] = p([Store Regions]), [Store ID]>}Sales)
Hi kumar, maybe with:
Sum({<Region>} sales)
Perhaps this?
Sum(TOTAL <[Store Region]> {<[Store ID]>} sales)
Hi Ruben,
No. Value is changing based on the store ID.
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.
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))
Sure. I will provide sample.
Hi Anil,
Please find the attached.
Try this
=Sum({<[Store Regions] = p([Store Regions]), [Store ID]>}Sales)
PFA