Skip to Content

Totals wrong in Shared Axis result of dependent report

Dear Experts,

We have a requirement to combine 2 different cross tabs using Shared axis (Combine).

CrossTab 1:

Product Qty

A 10

B 20

Total 30

********************

CrossTab 2:

Product OpenQty

A 15

C 20

Total 35

********************

After combine both tabs, result as follows :

Result :

Product Qty OpenQty

A 10 15

B 20

Result 30 35

********************

Merge results are perfectly working based on left outer join (Master - CrossTab 1, Dependent - CrossTab 2), but the issue is with Result row.

Qty total is 30 , but OpenQty total is showing as 35 ( which is equal to Crosstab 2 total , ie A + C = 35) instead of 15.

Is there any way to just add results based on available values in Result set of Dependent Measures? ( I tried Totals-->Calculate Total as -->Sum, but not working)

Thanks in advance...

Regards,

Raju


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 08, 2017 at 09:26 AM

    Hi - sorry for the delay in replying. Would it be possible for you to share some screen shots?

    One idea is to create an Excel formula for results; have you tried that?

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 09, 2017 at 06:10 AM

    Dear Tammy,

    Thanks for the response.

    Following are 2 cross tabs.

    After Merger with Totals

    I tried Excel formula, but its static.

    Thanks,

    Raju

    Add comment
    10|10000 characters needed characters exceeded