Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Genarating columns dynamically based on grouping in a table
VANITHAKB
<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
pricher
<p>Hi,</p>
<p> </p>
<p>Using a crosstab will create grouping horizontally as well as vertically. I am sure you can find many examples of crosstabs in this forum, but I have attached a simple one loosely based on your example to help you.</p>
<p> </p>
<p>Regards,</p>
<p> </p>
<p>P.</p>