Forum Discussion
Solved
Matrix visual help
Hi,
I am building the matrix visual
input
| Group | Status |
| 1 | B |
| 2 | A |
| 3 | C |
matrix that i got to is (each 1 is a count)
| Group | A | B | C |
| 1 | 1 | ||
| 2 | 1 | ||
| 3 | 1 |
i need to multiply each count by 80
| Group | A | B | C |
| 1 | 1*80 | ||
| 2 | 1*80 | ||
| 3 | 1*80 |
since each column is a transposed row, i dont know how to refer to it. maybe there is an easy way. i.e. calculated A
thank you
Without context I would say that you just need to create a measure like Measure = COUNTROWS(Status)*80 and put in the "Values" of the Matrix.
4 Replies
Without context I would say that you just need to create a measure like Measure = COUNTROWS(Status)*80 and put in the "Values" of the Matrix.
thank you . works great.
one more question if you dont mind.
step 2 that i need to do is to find the difference between columns B and C (result of transposing).
to provide more context i will provide a better example
Group A B C still in progress 1 3 3 1 =3-1 2 1 3 3 3 1 Group A B C Still in progress 1 240 240 80 =240-80 2 80 0 0 3 240 240 80
