Forum Discussion

Anya_T's avatar
Anya_T
Frequent Visitor
4 years ago
Solved

% calculation

Hi,

 

I have data as

ChapterCountCountry
6414634CA
6112089EU
628022CA
616720CA
625287EU
645084EU
645073US
394743CA
624449AU
613862CN
613849US
493437AU
852912CA

i want to calculate percentage of each chapter as per country wise and want to display in matrix form?

What should i do?

Expected Result

ChapterCountCountry%
6414634CA18.26%
6112089EU15.08%
628022CA10.01%
616720CA8.38%
625287EU6.60%
645084EU6.34%
645073US6.33%
394743CA5.92%
624449AU5.55%
613862CN4.82%
613849US4.80%
493437AU4.29%
852912CA3.63%
Total80161  

 

Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    Hi Anya_T 

     

    You can drag the Chapter field onto your table and then just click the little down arrow to the right.  You can then click on Show Value As, then select Percent of Grand Total / Column Total, etc.

     

     

    Hope this helps.

     

    Theo 🙂

     

1 Reply

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    Hi Anya_T 

     

    You can drag the Chapter field onto your table and then just click the little down arrow to the right.  You can then click on Show Value As, then select Percent of Grand Total / Column Total, etc.

     

     

    Hope this helps.

     

    Theo 🙂