Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi.
Is it possible to show a matrix with the two first columns fixed/frozen and the weeks columns change update in one table
Thanks
WEEK1 | WEEK2 | WEEK3 | ||
SALES | $1,000 | $500 | $600 | $800 |
GOAL 1 | 85% | 50% | 60% | 80% |
GOAL 2 | 90% | 50% | 60% | 80% |
GOAL 3 | 100% | 50% | 60% | 80% |
Hi @jsim100 ,
Based on my test, we cannot achieve that by a matrix. Maybe we can create two tables to work around.
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |