Not sure I fully understand what you mean...
The idea is to have ONE document where someone from from departement A gets to see data filtered to departement A (no details for Dep B, C, D etc) but that he gets the average over all (A, B ,C and D)
I have a .qvw with the full dataset and section access limiting someone from Dep A to Dep A related data but then I can't put it into context by showing the average over all the departements...
Thank you for the quick response!!!
That's not possible, as Siri points out above. If you need to have reduced all information by department, but keep in one chart the total corresponding to all departments, you will need to first aggregate in the script the sum of all departments in a different field and add it (using JOIN likely) to each department line.
Then, although you reduce data, you will see the correct results.
Check the attached app just in case. Users are ADMIN, DEP1 and DEP2. For ADMIN you should see both depts and all data, and the sum of 100%. For DEP1 and DEP2 you should see each one's data, but the corresponding to the total.
Hope that helps.
qcomAggrSectionAccess.qvw 150.0 K