Calculating crosstab data from 2 different queries

building reports webintelligence
1

I have 2 crosstabs containing data, the common factor is the week number:

table1

“ask” w1 w2 w3 w4 w5

snapshotw1 10 10 10 10 12
snapshotw2 12 10 10 11
snapshotw3 11 11 12
snapshotw4 11 12
snapshotw5 12

table2

“fill” w1 w2 w3 w4 w5

                 8      11   10   12    11

Needed : w1 w2 w3 w4 w5
delta 2 1 1 -1 1
delta %

I need to calculate the delta of “ask” - “fill” in qty and %, but any idea how to get the formula to count the last snapshot value from the “ask” for the corresponding “fill” week ?

Thanks in advance

JoE

jkeste (BOB member since 2009-01-27)

2

Simply join the dataproviders on week number and drag both the objects, create as simple variable to calculate the difference and percentage change.

deepak21.s :qatar: (BOB member since 2010-09-06)

3

Actually snapshotwk and the “ask” wk are from one query and the “fill” wk from another query. I can not link the snapshotwk and the “fill” wk :frowning:

jkeste (BOB member since 2009-01-27)

4

Try merging dimensions “ask” wk and “fill” wk and then form a single table.

lnarayanan86 :india: (BOB member since 2009-08-05)