How do i create like a table or quadrant summary?

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

  • Sumo table would be your best solution. 

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

  • 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

  • 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

  • @Godzilla, can you provide anymore insight?

    Thanks!

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

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

This discussion has been closed.