Selection on a table totally disconnected, affect other tables!

[#1]

Hi,

I got a table used for test on others, it's built with a resident.

I mean

B:

LOAD year as year1, B as B1,C as C1,D as D1 resident tableA;

I haven't got any other table with field call'd B1,C1,D1 or year1.

But when I make a selection on this table I noticed some changes on a Pivot containg expression based on totally different dimension

the expression which changes is smt like aggr(max(B), C1,D1) and the results are wrong!

I don't know what to do, it seems so strange to me.

I also noticed that if I open the same qvw file from the web, it works correctly...

Where is my error? Is there a Bug?

Thanks

[#2]

Hi!

You can send a example?

Rebeca Gums

[#3]

The problem is related to the Aggr formula, If I recharge the file, it changes from time to time!