Forum Discussion
Column in matrix visual
I have a matrix visual that shows aged debt, like this: Client name 0-30 31-60 61-90 ABC Ltd £100 £0 £200 DEF Inc £0 £10 £20 I'd like to include another column (ClientCo...
Hello Parker
Thanks for your reply.
Adding ClientCode to the Values well gives:
| Client name | 0-30 | 31-60 | 61-90 | |||
| First ClientCode | Amount | First ClientCode | Amount | First ClientCode | Amount | |
| ABC Ltd | 0001 | £100 | 0001 | £0 | 0001 | £200 |
| DEF Inc | 0002 | £0 | 0002 | £10 | 0002 | £20 |
Note how the client code appears multiple times.
I don't want to aggregate the ClientCode field - I just want to show it in a separatae column alongside the ClientName .
Mike
Are your "0-30", "31-60", "61-90" fields in the Values well also? If not, try to put them there. You'll have Client name in the Rows and your other 4 fields in the Values.
Let me know if that works,
Parker