Forum Discussion

affan's avatar
affan
Solution Sage
7 years ago
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...
Need Help
Tips and Tricks
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Share some dource data.

  • affan's avatar
    affan
    Solution Sage
    7 years ago

    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.

     

    Year201320112012
    GrossSalesQty137780831185192811270399
    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

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

       

      Click on the Format icon and under the Values section, swithch "On" the Show on rows option.

       

      Hope this helps.