How do i create like a table or quadrant summary?

sgraham

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

 

 

Q2 QTD YOY (Constant Currency)
	Americas	EMEA	APAC	Total
Div1
10	20	8	38
-5%	-3%	-4%	-4%
Div2
8	15	1	24
13%	44%	47%	16%
Div3
2	4	1.5	7.5
-17%	77%	-50%	-1%
Total
20	39	10.5	69.5
-1%	2%	-24%	-1%

Godzilla

Sumo table would be your best solution. 

sgraham

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

Godzilla

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. 

 

sgraham

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

@Godzilla, can you provide anymore insight?

Thanks!

Godzilla

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

kshah008

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