Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to show dimension columns dynamically by selecting values.
Used the below formula:
=SubStringCount(Concat(Lable, '|'), 'Job')
Requirement is I want show always 3 columns (EmpNo,Name,Sal) without selecting any value from the list box.
These are the values from the list box:
EmpNo
Name
Department
Job
ID
HireDate
Please help me in how to achieve this.
Hi,
Here is the solution.
Hi All,
If I want to show EmpNo,Name,Sal, these can be selected in Led Check box. But default it should be selected EmpNo,Name,Sal.
How can I achieve this?
Please help.
Hi,
Please find attached file for solution.
Regards,
Jagan.
FYI, i have used below condition
For default columns OR GetSelectedCount(Lable) = 0
For non default columns AND GetSelectedCount(Lable) <> 0
By default it will show the default columns even if not selected in the listbox, if selected then it will show the selected values in the chart.
Hope this helps you.
Regards,
Jagan.
Dear Jagan,
Many Thanks for your help.