Can we calculate field value based on Access type ?

[SRT10]

We gave field Revenue. There are 2 types of Revenue i.e. 1.Local Revenue 2. Global Revenue
Revenue = Local Revenue + Global Revenue

Local User is not allowed to see Global Revenue. So we have 2 situations like below -

1. If there is a user who has access to Local level,
We need to show only Local Revenue in Revenue column

2. If there is a user who has access to Global level,
We need to show Local Revenue + Global Revenue in Revenue column

Revenue column is viewed in various tabs of dashboards. 
is there any solution to handle this ?
Can we have some logic or set analysis when dashboard is refreshed and derive data based on access sheet.

QlikView 

[anat]

in section access create a flag like "local level" is 1 and global level is 0

create 2 expressions and show based on the  conditional

[SRT10]

you mean use if condition in chart properties/expressions ?

Is it good to use if there..