i have a sales model and an excell file (security) that holds sales managers names and related departments,
when sales managers accses the model they can see only their related department sales data.
all is working good and stable,
the only problem is the data reduce when nulls dissapear from the model, i guess not related with any depatment.
global sales manager (opened for all departments) canot see the correct total.
when reloading the model it comes back - save and open and its gone ..
- unchecked the reduce data from security tab.
- 'None' compression in save tab
any recomendetion for solving this issue or other security options?