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)
Sub total(sum column values)
dir_viswa
I just want to add some datasetRow's(cell's of a report like total marks). pls suggest. tnx
Find more posts tagged with
Comments
mwilliams
Can you explain more? Are you wanting to know the total across a row of different columns? Are you wanting to sum a row? Are you wanting to count values? Let me know and I can be more specific.
As for doing totals, counts, and many other functions on your data, you can either create a computed column in your dataSet and write an expression or use an aggregation function, or you can add aggregations to your table with a palette element.
dir_viswa
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="109228" data-time="1347463662" data-date="12 September 2012 - 08:27 AM"><p>
Can you explain more? Are you wanting to know the total across a row of different columns? Are you wanting to sum a row? Are you wanting to count values? Let me know and I can be more specific.<br />
<br />
As for doing totals, counts, and many other functions on your data, you can either create a computed column in your dataSet and write an expression or use an aggregation function, or you can add aggregations to your table with a palette element.<br /></p></blockquote>
<br />
Thanks for ur reply. Lets see an example scenario <br />
<br />
English | 69<br />
maths | 90<br />
science | 87<br />
social | 79<br />
<br />
Total | ?<br />
<br />
total is i want to get.
mwilliams
If you have a table, like the one above, you'd simply put a label in the table footer, under the subjects column, and type "Total" into it. Then, drag an aggregation element, from the palette, to your table footer's other column and use the SUM aggregation on the value field. Hope this helps. Let me know.
dir_viswa
Thanks boss. It works.
mwilliams
You're welcome. Let us know whenever you have questions!