Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i want the below format
Current matrix report | |||||
stage 1 | stage 2 | stage 3 | stage 4 | Count | |
camp1 | 5 | 1 | 8 | 14 | |
camp2 | 1 | 1 | 1 | 1 | 4 |
camp3 | 2 | 2 | |||
camp4 | 1 | 2 | 3 | 6 | |
camp5 | 2 | 4 | 6 | ||
I want vaues of stage 3 against camp in report | |||||
stage 3 | Count | ||||
camp2 | 1 | 4 | |||
camp4 | 3 | 6 | |||
camp5 | 2 | 6 |
Solved! Go to Solution.
You can do one thing.
After Placing data on to the matric table. You go to the Visual Filter secton, there under Stage 3, select Is not blank.
You could simply ignore other stages in Matrix columns?
excludin other stages impacting the total count.
any way thanks for you though.
I see that you edited your Question. In the First version, there are blank included in the Stage3 (expecting result).
yes.. as there is no values for stage 3 i ahve removed those camps intentinally.
even if they display also no matters.
You can do one thing.
After Placing data on to the matric table. You go to the Visual Filter secton, there under Stage 3, select Is not blank.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |