Distribute total

[PepeMontes]

Hello dear experts,
I have a dynamic table where i have a few fields, into those fields i have Sales and Stores.
I'm trying to distribute equitably the total of the Sales of all stores into
12 specfic stores, excluding the other stores and distributing this total to only this specific stores..
This is the expresion which im using to try it:
Sum({$<[Stores]={"CEDIS GAVILAN MATRIZ","CEDIS ZAPOPAN","GUADALAJARA","LEON","LIVERPOOL","MODERNA","MONTERREY","PUEBLA","QUERETARO","TIJUANA","TOLUCA","XALAPA"}>}Total([Sales))/12

Unffotunally this expression dont row me the result which im looking for.

I will appreciattte if someone could help me with this.

Best Regards.

JAMM.

[Kashyap_R · Accepted solution]

Hi 

Try this

In Dimension write the below expression and remove null values

IF(Wildmatch([Stores],'CEDIS GAVILAN MATRIZ','CEDIS ZAPOPAN','GUADALAJARA','LEON','LIVERPOOL','MODERNA','MONTERREY','PUEBLA','QUERETARO',
'TIJUANA','TOLUCA','XALAPA')<>0,[Stores])

In Measure give this

Sum(Total [Sales)/12

or

Sum(All [Sales])/12

 Hope this helps

Thanks