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)
How to group like this table?
cynvy
<p> The aimed table is as follows:</p>
<p>
Find more posts tagged with
Comments
sidrees
<p>Hi,<br><br>
If you can provide the sample in English I might be able to help you better,<br><br>
Looks you have used CrossTab, select the crosstab and then in Property Editor you have two options RowArea and ColumnArea<br><br>
Select the RowArea then from the left menu select GrandTotals and click Add then select the DataField, this will sum up the row data</p>
<p>
cynvy
<blockquote class="ipsBlockquote" data-author="sidrees" data-cid="143907" data-time="1463552760">
<div>
<p>Hi,<br><br>
If you can provide the sample in English I might be able to help you better,<br><br>
Looks you have used CrossTab, select the crosstab and then in Property Editor you have two options RowArea and ColumnArea<br><br>
Select the RowArea then from the left menu select GrandTotals and click Add then select the DataField, this will sum up the row data</p>
<p><img src="
http://developer.actuate.com/community/forum/public/style_images/developer_actuate_images/attachicon.gif"
; alt="attachicon.gif"><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/index.php?app=core&module=attach§ion=attach&attach_rel_module=post&attach_id=13258'>Screen
Shot 2016-05-18 at 11.13.05 AM.png</a></p>
<p> </p>
<p>ColumnArea is used if you want to add the totals for columns</p>
</div>
</blockquote>
<p> </p>
<p>thank you, sidrees</p>
<p>I added a .xlsx file which shows the wanted displaying form and the raw data in English.</p>
<p>I want to merge cells with the same value for a special column on the retrieved data, </p>
<p>It's like grouping, but the grouping title is alaways on the top of each group data.</p>
<p>I didn't use crosstable, I'll try.</p>
<p>
sidrees
<p>Hi,<br>
</p>
<p>As per your requirement I think you should use CrossTab,</p>
<p>you need something similar to this example
cynvy
<blockquote class="ipsBlockquote" data-author="sidrees" data-cid="143913" data-time="1463567169">
<p>Hi,<br>
<br>
As per your requirement I think you should use CrossTab,<br>
you need something similar to this example <img src="
http://developer.actuate.com/community/forum/public/style_images/developer_actuate_images/attachicon.gif"
; alt="attachicon.gif"><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/index.php?app=core&module=attach§ion=attach&attach_rel_module=post&attach_id=13262'>Screen
Shot 2016-05-18 at 3.20.12 PM.png</a><br>
<br>
Download this book and go through the Chapter 20, I hope it has all you need otherwise<br>
</p>
</blockquote>
<p>Hi,sidrees<br>
I have gone through <span style="font-size:12px;">the crosstab Chapter of the book you recommended, and the final format of crosstab is very like my table. But I found that I have no field for the </span><span style="font-size:12px;">columns which is necessary for the crosstab, the raw data is as follows:</span></p>
<p> </p>
<p>
sidrees
<p>Hi cynvy,<br>
</p>
<p>Looking at the left part the original data, crosstab should fit easily to your requirement,</p>
<p> </p>
<p>You need to create three Dimension (Area, Company and Type) and one Summary (Value) field, have a look if this help you?
