Visokio website     Downloads     Video tutorials     KnowledgeBase  
Pivot View: Displaying percentages? - Visokio Forums
Pivot View: Displaying percentages?
  •     Valentina April 24, 2014 3:41AM
    I created a Pivot view and I want to convert the numerical values to percentages ideally for row total. Any ideas how to do this?

    Thanks in advance
  • 4 Comments
  •     paola April 24, 2014 4:52AM
    Could you please post an example and explain how would % calculation work? Thanks
  •     Valentina April 24, 2014 5:13AM
    Hi Paola,

    Assume I created the following Table in the Pivot View.

    Name FirstStep SecondStep ThirdStep Total
    John 3 17 7 27
    Maria 14 12 6 32
    George 5 5 8 18
    Stella 21 3 4 28

    Eventually I want to convert the numerical values in % based on the rows and not the columns like below.

    Name FirstStep SecondStep ThirdStep Total
    John 11% 63% 26% 100%
    Maria 44% 38% 19% 100%
    George 28% 28% 44% 100%
    Stella 75% 11% 14% 100%
  •     paola April 24, 2014 8:53AM
    It might be easier if you add % fields with formulas and format them as %:
    [FirstStep]
    /
    ([FirstStep]+[SecondStep]+[ThirdStep])


    In case of multiple records with the same [Name]:

    SUBSET_SUM([FirstStep], subset([Name]))
    /
    (SUBSET_SUM([FirstStep], subset([Name]))+SUBSET_SUM([SecondStep], subset([Name]))+SUBSET_SUM([ThirdStep], subset([Name])))
  •     Valentina April 24, 2014 9:07AM
    Thanks a lot Paola.
This discussion has been closed.
← All Discussions

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership