Hi Gang - Question for the general forum. I have raw data reported by our server that isnt exactly an optimal configuration for QV. That is, instead of having two columns for product line revenue (one for product line and one for revenue); the data is combined into one column "product line revenue."
I want to user to be able to simple click the Product Line. Is there a fuction that allows to QV to reorganize the data to the desired format?
Current Format
| Product Line A Revenue | Product Line B Revenue
| Product Line C Revenue
|
|---|
| $100 | $50 | $200 |
Desired Format
Product Line
| Revenue
|
|---|
| A | $100 |
| B | $50 |
| C | $200 |
