Forum Discussion
Nested Axis
richard_wylde wrote:
Hello v-juanli-msft
I've almost managed to recreate your matrix by moving the dimensions into the Values, but the only problem now is that it automatically summarizes just the first value, so it is showing only one record per Insurer_Name. Is there a way to resolve this ?
Add name, code columns in the "ROW" field of the matrix instead of "VALUE" field.
Look at my example
I will show the detailed steps one by one:
turn off "Stepped layout".
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello v-juanli-msft
I've almost managed to recreate your matrix by moving the dimensions into the Values, but the only problem now is that it automatically summarizes just the first value, so it is showing only one record per Insurer_Name. Is there a way to resolve this ?
richard_wylde wrote:
Hello v-juanli-msft
I've almost managed to recreate your matrix by moving the dimensions into the Values, but the only problem now is that it automatically summarizes just the first value, so it is showing only one record per Insurer_Name. Is there a way to resolve this ?
Add name, code columns in the "ROW" field of the matrix instead of "VALUE" field.
Look at my example
I will show the detailed steps one by one:
turn off "Stepped layout".
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.