Forum Discussion
Solved
Multiple Measures to be plot on Row and Column
Hi I am trying to create a report where I have multiple measures to be shown as below Jan Feb MOM Comparison Gross Volume 5353328.352 4550329.099 802999.2528 Net Volume 401499...
Hi,
Click on the Format icon and under the Values section, swithch "On" the Show on rows option.
Hope this helps.
Hi,
Share some dource data.
Hi
Attached is a sample data source I am using for understanding purpose.
My initial requirement is to see the measures as row heders
As of now I can create a visual where I have the Years on rows and measures on columns. But my need is something to transpose it.
| Year | 2013 | 2011 | 2012 |
| GrossSalesQty | 13778083 | 11851928 | 11270399 |
| NetSalesAmount | $2,487,236,058.13 | $3,058,401,994.15 | $2,571,729,210.95 |
| GrossSales | $2,554,417,855.67 | $3,144,393,292.13 | $2,642,413,217.03 |
Regards
Affan
Hi,
Click on the Format icon and under the Values section, swithch "On" the Show on rows option.
Hope this helps.