Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 tables which are not associated to one another but have the same dimension valuesI would like to display the sum of values for second table with respect to first table dimensions
.
LOAD * INLINE [ A, B, C A1, B1,11 A2, B2,21 A3, B3,31 ]; LOAD * INLINE [ X, Y, Z A1, B1,10 A2, B2,20 A3, B3,30 ]; The result must be, even when selections(B=B1) are made: A =Sum(Z) - A1 10 A2 20 A3 30 But they are, when I select B=B1 : A =Sum(Z) - A1 10 A2 A3
I am not sure if this is what you are looking for, but take a look at the qvw file.
Best,
S