how forbid assumble function in Summary Filed

how forbid assumble function in Summary Filed of crosstab and can show originally??? pls give a idea, thx for advance.

sincerely kevin:)

Find more posts tagged with

Comments

mwilliams

Hi Kevin,

Can you explain more about the problem you're having? Thanks.

kevin23_hy

I wanna forbid "function"option to null. mean dont use assemble function however to show that field originally! so can any way to implementation?

pls help in emergency.

mwilliams

Kevin,

So, you want to disable the summation on that field in the crosstab? If so, try selecting "first" from the drop down in the function box rather than sum. This will just show the first value from that field rather than summing them. Let me know if this is not the result you're wanting.

kevin23_hy

o,so that explain it. but i also wandering each of selection exactly meaning.
so has any article to explain it, hope contributed to all.

thx a lot for michael:)

BTW,pls check the email i sent about exchanging.

mwilliams

Kevin,<br />
<br />
I found this in the <a class='bbc_url' href='http://www.birt-exchange.com/documentation/BIRT_210/wwhelp/wwhimpl/js/html/wwhelp.htm'>online documentation</a>:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
ave( expr [, filter [, group ]] )
The mathatical mean of a set of values

count( [ filter [, group ]] )
The count of rows

countDistinct( expr [, filter [, group ]] )
The count of distinct values

first( expr [, filter [, group ]] )
The first value in a sequence

isBottomN(expr, n, [, filter [, group ]] )
A boolean inicating if the value is one of the bottom n values

isBottomNPercent( expr, percentage, [, filter [, group ]] )
A boolean inicating if the value is in the bottom n percent of values

isTopN(expr, n, [, filter [, group ]] )
A boolean inicating if the value is one of the top n values

isTopNPercent( expr, percentage, [, filter [, group ]] )
A boolean inicating if the value is in the top n percent of values

last( expr [, filter [, group ]] )
The last value in a sequence.

max( expr [, filter [, group ]] )
The maximum value of a sequence of numbers, strings, or dates

median( expr [, filter [, group ]] )
The mathematical median of a sequence of numbers

min( expr [, filter [, group ]] )
The minimum value of a sequence of numbers, strings, or dates

mode( expr [, filter [, group ]] )
The mathematical mode of a sequence of values

movingAve( expr, window [, filter [, group ]] )
A running average of a sequence of numbers in which the user specifies the number of values to consider when computing the average

percentile( expr, percentage [, filter [, group ]] )
The percentile value for a set of values

percentileRank( expr [, filter [, group ]])
The rank of a value as a percentage of the data set

percentSum( expr [, filter [, group ]])
The percentage of a total

quartile( expr, quartile,[ filter [, group ]])
The quartile value of a set of values

rank( expr, ascending, [, filter [, group ]])
The rank of a value

runningCount( [, filter [, group ]]
The count of items

runningSum( expr [, filter [, group ]] )
Similar to sum, but shows the running total to a given point in the report.

stdDev( expr [, filter [, group ]] )
The mathematical standard deviation of a sequence of numbers.

sum( expr [, filter [, group ]] )
The sum of a sequence of numbers

variance( expr [, filter [, group ]] )
The mathematical variance of a sequence of numbers.

weightedAve( expr, weight [, filter [, group ]] )
The weighted average of a sequence of numbers
</pre>