nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Variance in crosstab

ReinerE

Hello again,

second (hopefully easy) question.
I would like to compare two columns of a crosstab.

rows = weeks
columns = 2010 and 2011

Any hint for me?

Thx!

-> Any recommendation for a good BIRT Book for Beginners?

Find more posts tagged with

Comments

Hans_vd

Hi ReinerE,

If you select the crosstab, go to the properties Editor and choose the column area tab: add a total column
Now you can change the expression or the function (default it is SUM) as you want.

Regards
Hans

mwilliams

The Eclipse Series offers a great book for designing BIRT reports.

http://www.amazon.com/BIRT-Field-Guide-3rd-Eclipse/dp/0321733584/ref=dp_ob_title_bk

ReinerE

<blockquote class='ipsBlockquote' data-author="'Hans_vd'" data-cid="80513" data-time="1311604487" data-date="25 July 2011 - 07:34 AM">
Hi ReinerE, 
 
If you select the crosstab, go to the properties Editor and choose the column area tab: add a total column 
Now you can change the expression or the function (default it is SUM) as you want. 
 
Regards 
Hans </blockquote>
 
Hi Hans, 
 
thx for your help again! Add a total column works perfect! But if i change the SUM function to Variance (Expression and Aggregate on like SUM) I get a "false" result. 2010: 26317 2011: 36755 varinace: 54693876,25 
I feel like going to primary school again

Regards 
 
Reiner 
 
@Michael book is orderd! thx!

Hans_vd

That's wrong indeed.

Do you have filters on your crosstab?
What datatype did you use for the totals column?

And what happens if you execute the same report with small numbers? Is it correct then?

Regards
Hans

ReinerE

<blockquote class='ipsBlockquote' data-author="'Hans_vd'" data-cid="80578" data-time="1311681397" data-date="26 July 2011 - 04:56 AM">
That's wrong indeed. 
 
Do you have filters on your crosstab? 
What datatype did you use for the totals column? 
 
And what happens if you execute the same report with small numbers? Is it correct then? 
 
Regards 
Hans </blockquote>
 
no filters 
datatype integer 
Error: 
Data (id = 2502): 
+ Retrieving binding data error.

Hans_vd

Hi ReinerE,

The binding error probably comes from removing a dimension or computed value from the cube or dataset without removing it from the crosstab bindings. Select the crosstab and check in the bindings tab.

Did you try to work with smaller numbers?