Forum Discussion

Jaap's avatar
Jaap
Regular Visitor
8 years ago

Multiple matrix to one chart

I have few tab's on my desktop. They all have the same matrix but different (page)filters are applied. I want to draw a chart based on these different outcomes. I would make sense if I could copy all the outcomes of the various matrix to a new dataset or table, but I can't find out how to do this. The simplied version of my matrix look like this:

 

tab1;

client  cash ratio

A         100%

B         77%

C         71%

 

tab2;

client  cash ratio

A         91%

B         73%

C         61%

 

tab3;

client  cash ratio

A         83%

B         54%

C         36%