Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Genarating columns dynamically based on grouping in a table
Migrateduser
<p>Hi Guys,</p>
<p> </p>
<p>i have come up with a tricky requirement (might not be tricky for u guys)<br><br>
I have a table in a layout and have grouping on one column.<br>
now i want each group to be displayed in separate column</p>
<p>i have given a sample table structure below</p>
<p> </p>
<p><u>Entity ID</u> <u>TimeStamp </u> <u>Value</u></p>
<p><strong>com_01</strong> </p>
<p>com_01 May 5, 2015 5:30 AM 49.79</p>
<p>com_01 Jun 4, 2015 5:30 AM 50.19</p>
<p><strong>com_02 </strong></p>
<p>com_02 May 5, 2015 5:30 AM 50.52</p>
<p>com_02 Jun 4, 2015 5:30 AM 49.78</p>
<p><strong>com_03</strong></p>
<p>com_03 May 5, 2015 5:30 AM 49.77</p>
<p>com_03 Jun 4, 2015 5:30 AM 50.23</p>
<div style="text-align:center;"> </div>
<p>here Grouping done on Entity ID column and this entity Id is selected from user, multiple selection allowed.</p>
<p>now i want the above table to look like as follows</p>
<p> </p>
<p> </p>
<p><u>TimeStamp</u> <u>com_01 (first group)</u> <u>com_02(second group)</u> <u>com_03(3rd group)</u></p>
<p>May 5, 2015 5:30 AM 49.79 50.52 49.77</p>
<p>Jun 4, 2015 5:30 AM 50.19 49.78 50.23</p>
<p> </p>
<p> </p>
<p> </p>
<p>is it possible like this??<br>
pls help</p>
<p>Thanks in advance</p>
Find more posts tagged with
Comments
There are no comments yet