Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys, I have a requirement as below, Can you please help me how to achieve this
I will have a table(Straight Table with 5 measures and 5 dimensions), I have a hierarchy fields Region,Director,opsmanager,supervisor, Now at opening the dashboard I should not have any dimensions displayed, The user will select Region value and according to the selected value Directors of the region needed to be displayed and then user will select Director value then opsmanager under that director needed to be displayed in place of director column. the selections will be made until last value of hierarchy, The question here is how can show only one column according to the selection. I have attached excel with dummy data and output required, Can somebody look into it please? I am on PE so can't open your application, Can you explain me or any screenshots will be really helpful.
Thanks a lot
I have taken only four dimension in a Straight Table and Added a Expression as =1 . Hide this expression from Straight Table Presentation tab.
Now go to dimension tab and add the If condition in enabled condition section for each of the dimention as given below
Region: if(SubStringCount(GetCurrentSelections(),'Region'),0,1)
Regional Operator : if(SubStringCount(GetCurrentSelections(),'[Regional Operator]'),0,1)
Ops Manager : if(SubStringCount(GetCurrentSelections(),'Ops Manager'),0,1)
Engineer Name: if(SubStringCount(GetCurrentSelections(),'Engineer Name'),0,1)
Value : if(SubStringCount(GetCurrentSelections(),'Engineer Name'),1,0)
Also Now Go to Presentation Tab add Condition for Each columns as Given Below
Region: Show Column
Regional Operator : if(GetFieldSelections(Region)>0,1,0)
Ops Manager : if(GetFieldSelections([Regional Director])>0,1,0)
Engineer Name: if(GetFieldSelections([Ops Manager])>0,1,0)
Value : Show Column
=1 : Hide Column
Hi Pritam,
Thanks for the effort, It is only showing only column at a time which as required, but the problem is it is not totaling the value, for example if I select region it's associated regionaldirectors are coming up but due to already there are columns opsmanager,contractmanager so onn.....it is showing each individual value instead of group by regional director at that selection, Please see the attached what I have done for your understanding, How can we achieve this? thanks again
Anybody can help please?