Forum Discussion

Aruna_ln's avatar
Aruna_ln
Icon for Helper III rankHelper III
9 years ago
Solved

how to create labael and calculated values

 

I have table

col1,col2,col3

 

My reports i need labelname:calculated values

like below example

 

sum colA : 63

Total Calculated values:5 mean this values coming from ColA/Col2

 

this type of calculation  i have 10 rows

that 10 rows look like table

I need labelname then calulated values.

 

please anybody help me.

 

 

thanks

Aruna

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Aruna_ln,

     

    You resource table looks like the following screenshot? 



    If it is, you can unpivot the columns by select the three columns->unpivot columns in Query Editor, you will get the result.



    Then you can create a table visual to display what you want.



    If this is not what you want, please share your sample data for further analysis.

    Thanks,
    Angelia

3 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Aruna_ln,

     

    You resource table looks like the following screenshot? 



    If it is, you can unpivot the columns by select the three columns->unpivot columns in Query Editor, you will get the result.



    Then you can create a table visual to display what you want.



    If this is not what you want, please share your sample data for further analysis.

    Thanks,
    Angelia

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Aruna_ln,

    Have you resolved your issue, please mark the helpful reply as answer. Thanks fpr understanding.

    Thanks,
    Angelia