I have applied formatting to a list of cost centers in a straight table. The formatting assigns cell colors based on expense variance - i.e. top ten are green and bottom ten are red. The formatting works fine when viewing all cost centers. However this application has section access built into it. When users view the table, the formatting is then applied only to those cost centers they can view. Is there a way to maintain the global level formatting when access is limited? The users do have the ability to select different years and months.
If you want to keep some data attributes independent from selection or data reduction, you have to do something about that in the script. In your case, define top and bottom in the script, and assign some flags to them. On the front end, use the flags a color conditions.
If you want to keep some data attributes independent from selection or data reduction, you have to do something about that in the script. In your case, define top and bottom in the script, and assign some flags to them. On the front end, use the flags a color conditions.
