Forum Discussion

unnijoy's avatar
unnijoy
Post Prodigy
8 years ago
Solved

Category wise %

I have traing completion %. Based on that we have given catogery for each trainer. The catogery are AB&C. Some times for a month one trainer may come under A 2 times B 1 time and C 4 Times. I need a ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

     

    So all you need to do is add a column chart then put the category as the axis, the month as the legend then drag the completion to the values and it will create a stacked column with the same values as the chart.

unnijoy's avatar
unnijoy
Post Prodigy
8 years ago

Thanks for the reply.

 

Jan 55 % iu just gave as an example.

 

I got his in Matrix table format. I got stuck with the graph. I need to show catogry wise in graph. In bargraph i need to show this.

 

In that when i put this i am not getting this. 

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi unnijoy,

 

I am not very clear about the syntax for percentage calculation. Could you illustrate your desired result with examples? What does below aluehighlighted vs should be based on the first table?

 

Best regards,

Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Is this what you are looking to create?

    • unnijoy's avatar
      unnijoy
      Post Prodigy
      8 years ago

      Yes. And i need to show the same in a stacked Column chart.

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

         

        So all you need to do is add a column chart then put the category as the axis, the month as the legend then drag the completion to the values and it will create a stacked column with the same values as the chart.