How do i create like a table or quadrant summary?

sgraham
sgraham Member
in Archive

How do I create something like this?  but colour coded.  Red for decrease, Green for increase.

 

 

Q2 QTD YOY (Constant Currency)
 AmericasEMEAAPACTotal
Div1    
1020838
    
-5%-3%-4%-4%
Div2    
815124
    
13%44%47%16%
Div3    
241.57.5
    
-17%77%-50%-1%
Total    
203910.569.5
    
-1%2%-24%-1%

Comments

  • Godzilla
    Godzilla Contributor

    Sumo table would be your best solution. 

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • sgraham
    sgraham Member

    That certainly helps, but still have difficulty identifying the $ vs % and then formatting both $ and % green or red based on % increase or decrease

  • Godzilla
    Godzilla Contributor

    In order to do this, you'll have to have the $ and the % as separate fields in your datasets(cant create beast mode fields in Sumo). Once you have all that in your dataset, you can create the Sumo table and set it to Pivot view. Add your $ and % columns as the value fields and then click on the column headers in the pivot which will give you the menu below. Select Conditional Formatting and you'll get to the screen where you enter your criteria/conditions. Do the same for all the columns you want to apply conditional formatting to. 

     

    Capture.JPG

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • sgraham
    sgraham Member

    hmmm.  I am still unable to have a Div on left and a box to right that has $$ and % and both are conditional formated to red or green based on % change

     

    Instead i have Div a column for $, a column for % and can format % with colour

     

     

    Rgds

  • kshah008
    kshah008 Contributor

    @Godzilla, can you provide anymore insight?

    Thanks!

  • Godzilla
    Godzilla Contributor

    can you provide a screenshot of what you're getting?

    Domo Arigato!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
  • kshah008
    kshah008 Contributor

    @sgraham, tagging you to check out Godzilla's latest reply.

This discussion has been closed.

Categories