Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have two tables , having 100 columns each.
I want a list box that would show the table names and when click on the table names , we need table data to be populated in the straight table or Pivot table.
Could you please suggest how to get this done.
A suggestion:
Depending on the selection you make in your listbox, only one straight table will be shown at a time.
Best,
Peter
May be you are looking for something like this
If you are looking for something to convert a straight table to pivot or vice- versa. Then use the fast change option of charts.
Please see the attached.
By clicking on highlighted button chart will change to pivot and then again to straight chart.
Hi Ashis,
Like the following example?
Gyazo - e75c1effb255f0cfe2f254258b73cc18.gif
Hope this helps you.
With kind regards,
Ronald
A suggestion:
Depending on the selection you make in your listbox, only one straight table will be shown at a time.
Best,
Peter
Thank you Peter for your reply.
It is working as you suggested.
However in real scenario i have around 150 columns in one table , so manually adding this columns in the straight table is difficult when we talk about two tables. as per your suggestion below:
>Now create two straight tables, each showing the 100 columns of a different internal table or whatever you need to be visible. Place them on top of each other and resize them so that they match.
Is there any way i can populate the field values instead of manually adding them in the dimension tab.
Thank you,
Ashis
Hi Sunny,
Thank you for your quick reply. I am looking similar concept however differently. i need all the fields value in the straight table when choose the name of the table from list box. I will only have table name list box.
Thank you,
Ashis
Thanks Kamal for your reply, however i am not looking to convert straight table to pivot or vice versa.
You might be able to use $Field and $Table to get this to work.... for more help, would you be able to share a sample to take a look?
Hi Ronald,
Yes , similar output, I will have list box only having names of the table and once click all the data of the table would be in straight table.
Thank you,
Ashis