Forum Discussion

aakif_aslam's avatar
aakif_aslam
Helper I
2 years ago

RLS - Sales contribution % using total sales

Hi,

 

I am calculating contribution % by Region and State using the total sales and I need to apply RLS in the report.

Since I'm using total sales in the measure, the issue occurs after applying the RLS by region and state. 

 

For any particular RLS  filter (zone/state) the total sales get filtered, and the contribution % shows 100%.

 

I need to keep the total sales measure unaffected by RLS to calculate the actual contribution of any region and state.

As this is filtered on a model level, cannot control the RLS filter on a visual level, open to suggestions/new approaches.

 

Please Help.

amitchandak 

parry2k 

Ritaf1983 

Idrissshatila 

Ashish_Mathur