Straight tables comparison

[#1]

Hi,

My requirement is I need to have two straight tables..one table has total level and 2nd table is at user based selection level..table1 shouldn't be changed by user selection..

for example consider my data...

Sales Person Region Sales

A                  US     $100

B                   CA     $200

C                   EU     $300

D                    AU     $400

User Selected AU

Table 1                                                                     

A                  US     $100

B                   CA     $200

C                   EU     $300

D                    AU     $400

Table 2

D                    AU     $400

Please let me know how to achieve Table 1.

[MayilVahanan]

Hi

     Use =Sum({1}RegionSales) as expression  in Table1

     = Sum(RegionSales) as expression in Table 2

Hope it helps

[Anonymous]

Hi, you can use Alternate states (comparative analysis) or detach one straight table. Check attached qvw. Alternative is working with set analysis to 'overrule' selections made. But that's a bit more work. Regards, Sander

[Anonymous]

Ok, the set analysis example was already given to you while I was replying. One remark: the last detach/attach state isn't saved with the doc when you exit. So less usefull. Leaves you with alternate states or set analysis.

Regards, Sander