Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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