Forum Discussion
Group Metrics to Display Vertically
So I have a dataset that looks something like this -
| Product | Plan Gross Sales | Plan Net Sales | Plan Profit | Quota Gross Sales | Quota Net Sales | Quota Profit | YAGO Gross Sales | YAGO Net Sales | YAGO Profit |
| Brand A | 120 | 80 | 40 | 115 | 80 | 45 | 100 | 75 | 45 |
I would like to group metrics and display in a visual like this -
| Brand A | Plan | Quota | Yago |
| Gross Sales | 120 | 115 | 100 |
| Net Sales | 80 | 80 | 75 |
| Profit | 40 | 45 | 45 |
How can I do this?
Hi nj-matt ,
Check the following steps in Query editor.
1# Select Product column use Unpivot other columns feature.
2# Add two custom columns as below.
3# Create the visual.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
nj-matt , refer if this can help
Hi nj-matt ,
Check the following steps in Query editor.
1# Select Product column use Unpivot other columns feature.
2# Add two custom columns as below.
3# Create the visual.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
