Use case:
I have a smart container populated from a spreadsheet. The data represents a 2-level capability model for the whole company. The spreadsheet contains also multiple columns with the number of applications associated to each level 2 capability, one column for each line of business (LOB). E.g., You can have a level 1 capability called “Human Resources Management” with a few level 2 children capabilities. One of those level 2 can be “Recruitment” which has a total of 17 applications associated to it, say 5 of those 17 belong to Investment Bank, 4 to Retail Bank, 5 to Asset & Wealth Management and 3 to Corporate.
I can use conditional formatting to color the boxes representing level 2 capabilities using the total number of applications mapped to them (17 in the example above).
What I would like to do, is to have a way to select a specific LOB, e.g. using a dropdown selector or shapes used as buttons, and refresh the color the boxes using the numbers for that LOB. So that as I change the selected LOB the diagram gets colored in a different way.
Since I have the data about the number of apps (both total and for each LOB), I could create a number of conditional formatting rules such as: “IF LOB = “Investment Bank” and APP # is between 51 AND 100 THEN set custom formatting: fill color to YYY”
Request:
If I could declare a page variable and use a dropdown / buttons / shapes / ? to set the variable’s value and then use that variable in conditional formatting rules, then I could create a powerful dynamic diagram that would support my and many other (I believe) use cases
Your privacy choices
