How to summarize on multiple cross tabs

[Former Member]

Dear Sirs/Madams

I have created a report in which I am using 2 queries.

For each query I have created a crosstab which looks like this:

Crosstab Query 1

Jan 2010 Feb 2010

-

---

Keyfigure 1 X1 X2

Keyfigure 2 Y1 Y2

-

---

Crosstab Query 2

Jan 2010 Feb 2010

-

---

Keyfigure 1 Z1 Z2

Keyfigure 2 A1 A2

-

---

I created a 3rd Crosstab in which I want to summarize (I created formulas for this):

B1= X1+Z1

C1= Y1+A1

D1=X2+Z2

E1=Y2+A2

The query would look like this then:

Crosstab Query 3

Jan 2010 Feb 2010

-

---

Keyfigure 1 B1 D1

Keyfigure 2 C1 E1

-

---

However, the values coming through are not correct.

Did anyone have this problem as well?

If so, how did you solve this?

Is there a way to solve this issue?

Thanks in advance for your replies.

Kind Regards,

Joep

[former_member11696]

Please re-post if this is still an issue or purchase a case and have a dedicated support engineer work with you directly:

http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage&parentCategoryID=&categoryI...