How to add percentage in the pivot table?

ndldty
ndldty Member
in Charting

Hi,

I'm new to Domo. Is there any way how to add a percentage in the pivot table? So, besides the total, I would also like to know the percentage of each category.


Thank you.

Tagged:

Best Answers

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach

    It's also worth pointing that sometimes you can achieve the same look by using the mega table, which will give you the option to just check a box to get percent of total instead of having to write a beast mode.

    image.png

    This will depend on how you are wanting to present the data, but is worth looking into.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • ndldty
    ndldty Member

    Hi @amehdad thank you for the suggestion. I just tried using the formula you have suggested, and somehow I got an error.

    I create a pivot table card based on the data that I have.

    226.PNG

    I would like to show the percentage in the column, so it will look like this spreadsheet pivot table that I previously create

    225.PNG

    I'm using the formula you've suggested:

    Sum('Employee')

    /

    Sum(Sum('Organization')) over (partition by 'Employee')

  • ndldty
    ndldty Member

    it says:

    "An issue has occurred during processing. We are unable to complete the request at this time."

  • ndldty
    ndldty Member

    Sorry, I just have time to try it. It's working now. Thanks for the suggestion. @amehdad

Categories