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)
Get several data rows need just one
crusso
<p>Hi, Im trying to build a report using a .csv file, from the "recruitingV2#RCM_APP_STATUS_AUD#CREATED_DATE" field i need to have one column for each date.</p>
<p> </p>
<p>Can anyone have a good guess on how to achive this?</p>
<p> </p>
<p>Thanks</p>
Find more posts tagged with
Comments
pricher
<p>Hi,</p>
<p> </p>
<p>The easiest way to get one column per date is to create a data cube and use a cross tab instead of a table to display the data.</p>
<p> </p>
<p>Hope this helps,</p>
<p> </p>
<p>P.</p>
crusso
<p>I have created the cube and the crosstab, now i need my column to be ordered by a particular way, how can i achieve that? and is it possible to format the crosstab and adding more columns?</p>
shamo
<p>Its possible to use an expression in your sort order by assigning numbers to the order you want it sorted.</p>