Pivot Table

Lara
Lara Member

Is there a way to do conditional formating based on another column directly in pivot table?

 

Example: color in green if value in column A > then in column B

 

Thanks 

Best Answer

  • Jaketh13
    Jaketh13 Contributor
    Answer ✓

    Hey @Lara,

     

    It's not currently possible to set color rules of off the two columns you're comparing. The column the conditional formatting is applied to needs to be a static value in the visualisation as well. You could create a column that gives the difference or even just flags the rows where column A > column B and set a rule off of that column.


    Thanks,
    Jake
    **Say "Thanks" by clicking the "heart" in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Answers

  • Jaketh13
    Jaketh13 Contributor
    Answer ✓

    Hey @Lara,

     

    It's not currently possible to set color rules of off the two columns you're comparing. The column the conditional formatting is applied to needs to be a static value in the visualisation as well. You could create a column that gives the difference or even just flags the rows where column A > column B and set a rule off of that column.


    Thanks,
    Jake
    **Say "Thanks" by clicking the "heart" in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Lara
    Lara Member

    Thank you!!

  • Darius
    Darius Domo Employee

    user08705,

     

    Than you for reaching out! Applying conditional formatting based on a different column is not currently a feature in Sumo Cards (where pivoting is available). Please search our Ideas exchange here https://dojo.domo.com/t5/Ideas-Exchange/idb-p/Ideas. If your idea exists then vote it up, otherwise submit your idea so others can vote it up.


    Darius Rose
    **Say “Thanks” by clicking the “heart” in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Hi ,

     

    Can we add beast Mode functionality in SUMO cards?

    Please reply if you found any solution for this.Thanks

     

    Thanks & Regards,

    Rashid

     

     

     

     

  • I reading this information: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Pivot_Table_-_BETA

     

    Where is this located when creating a new card, Pivot Table?

This discussion has been closed.