thank you for your answer.
for num 2 i created a mapping table but was hoping for maybe a better solution...
for num 1, I’ll try to explain:
lets say you have a budget and actual for 6 different activities.
now, in specific situations, some activities need to be excluded from the total view, for example its budget is run in a different department...
in that case, i would like to create a click action that in one click will exclude these activities (they are constant and predefined) from to total view, in order to see a better picture of my actual vs. budget.
Can you share a list of your name project , corrects and uncorrect to test different solutions ?
It could be an interesting functionnality to develop.
1: A list box with activities isn't a good solution in this case ?
You also can create a table with department associated to activity. By selecting a specific department, you will show only interesting activities.
sorry, cant share the list of projects at the moment.
i'll think of somthing on that issue and let you know.
no, a list box will not be good enough. i already have a few of them on the page.
but, these specific values exclusion needs to be user friendly since not every one who looks at the budget knows which values to exclude and than one will see a wrong picture of actual exceeding budget,
and that is not what they need to see....