Hi,
Can someone please help me with this?
I have this table
Dynamic list for Vendor: James
Dynamic list for months: Feb-20
Only for Type of Contract R, how can I get a sorted table like this?
Thanks,
Edu
Can someone please help me with this?
I have this table
Revenue | Revenue | Revenue | ||||
Contract | Client | Vendor | Type of Contract | Jan-20 | Feb-20 | Mar-20 |
A1 | YY | James | R | 10 | 100 | 10000 |
A2 | VV | James | D | 20 | 200 | 20000 |
B4 | ZZ | Kevin | D | 30 | 300 | 30000 |
B2 | ZZ | James | R | 40 | 400 | 40000 |
A6 | W | Mike | R | 50 | 500 | 50000 |
Dynamic list for Vendor: James
Dynamic list for months: Feb-20
Only for Type of Contract R, how can I get a sorted table like this?
Client | Revenue |
ZZ | 400 |
YY | 100 |
Thanks,
Edu