Same information different charts

[Anonymous]

Good day

I have a question, i am building my application using several Excel spreadsheet that contain exactly the same fields. What i am trying to achieve is the following, the chart on the left must shown total information of all entities and the chart on the right should have only the information of one entitiy.

Obviuosly as you can see both have the same info everytime i select something.

Please help

Thanks in advance

[swuehl]

If I understood correctly, create a field when loading your Excel files that identify your source:

LOAD

    'A' as SOURCE,

     FieldA,

     FieldB,

     ...

FROM YourExcelFile_A.xls;

LOAD

     'B' as SOURCE,

     FieldA,

     FieldB,

     ...

FROM YourExcelFile_B.xls;

...

[Just a demo, you don't need to explicite repeat the LOAD statements, if you can make the Source definition dynamic, e.g. by parsing FileName() ]

Then use a filter in your second chart to limit the records to one source (e.g. B), like

Sum({<SOURCE= {'B'}>} FieldA)

Sum({<SOURCE= {'B'}>} FieldB)