Hi All, I am trying to display the selected hierarchy level as a title in a button bar using the interaction, but too many values are being displayed unless we are at the bottom of the hierarchy. The value I have assigned to the button bar is concatenation of sa - fac - ac - gl As you can observe on the 1st image (capture 1), I have assigned the hierachy to the category of a bar chart. The first level of hierarchy is SA. So if I click on any one of the bar and select the section which have button bar, it should only display SA value and other should be missing. Similary if I drill further down to FAC level (3rd image -capture 3). Then on selecting the section, it should only display selected SA-FAC Value and so on. Currenlty, it resulting in all the combination of the next data item that I have used in concatenation. For example, on Hierarchy Level : SA->FAC, I clicked on sa2, then fac1. It is returning all the commbination of sa-fac with gl and ac. Is there any way I can show them as missing if there are multiple values ? or Is there any other way to show selected hierarcy level? I can create separate calc itens for sa - fac, sa - fac - ac and sa - fac - ac - gl combinations, but I am not able to create a formula using calculated items that will return this dynamically. PS- Button bar doesn't support aggregated measure. You can use the following code to create the table: data test;
input sa $ fac $ ac $ gl $;
datalines;
sa1 fac1 ac1 gl1
sa2 fac1 ac1 gl1
sa3 fac1 ac1 gl1
sa4 fac1 ac1 gl1
sa1 fac1 ac2 gl1
sa1 fac1 ac1 gl2
sa2 fac1 ac1 gl2
sa3 fac1 ac1 gl2
sa4 fac1 ac1 gl2
sa1 fac1 ac2 gl1
sa2 fac1 ac2 gl1
sa3 fac1 ac2 gl1
sa4 fac1 ac2 gl1
sa1 fac1 ac2 gl2
sa2 fac1 ac2 gl2
sa3 fac1 ac2 gl2
sa4 fac1 ac2 gl2
sa1 fac2 ac3 gl3
sa2 fac2 ac3 gl3
sa3 fac2 ac3 gl3
sa4 fac2 ac3 gl3
sa1 fac2 ac3 gl4
sa2 fac2 ac3 gl4
sa3 fac2 ac3 gl4
sa4 fac2 ac3 gl4
sa1 fac2 ac4 gl3
sa2 fac2 ac4 gl3
sa3 fac2 ac4 gl3
sa4 fac2 ac4 gl3
sa1 fac2 ac4 gl4
sa2 fac2 ac4 gl4
sa3 fac2 ac4 gl4
sa4 fac2 ac4 gl4
;
run; Please let me know if you need more information on it. I am using VA 7.1 Thanks
... View more