Based on some simple data I tried to create a special graphical presentation:
Furthermore, I created two formula fields.
Blockleft:
if {Sheet1_.amount}>0 then
Blockright:
if {Sheet1_.amount}<=0 then
color(255,255,200)
else
color(255,200,255)
Here are the data, an Excel sheet:year | number | month | amount |
2009 | 1 | jan | 100 |
2009 | 2 | feb | 200 |
2009 | 3 | mrt | 100 |
2009 | 4 | apr | 200 |
2009 | 5 | mei | -100 |
2009 | 6 | jun | 200 |
2009 | 7 | jul | 100 |
2009 | 8 | aug | 200 |
2009 | 9 | sep | -200 |
2009 | 10 | okt | 200 |
2009 | 11 | nov | 100 |
2009 | 12 | dec | 200 |
2010 | 1 | jan | 100 |
2010 | 2 | feb | 200 |
2010 | 3 | mrt | 100 |
2010 | 4 | apr | 200 |
2010 | 5 | mei | -100 |
2010 | 6 | jun | 200 |
2010 | 7 | jul | 100 |
2010 | 8 | aug | 200 |
2010 | 9 | sep | -200 |
2010 | 10 | okt | 200 |
2010 | 11 | nov | 100 |
2010 | 12 | dec | 200 |
2011 | 1 | jan | 100 |
2011 | 2 | feb | 200 |
2011 | 3 | mrt | 100 |
2011 | 4 | apr | 200 |
2011 | 5 | mei | -100 |
2011 | 6 | jun | 200 |
2011 | 7 | jul | 100 |
2011 | 8 | aug | 200 |
2011 | 9 | sep | -200 |
2011 | 10 | okt | 200 |
2011 | 11 | nov | 100 |
2011 | 12 | dec | 200 |
2012 | 1 | jan | 100 |
2012 | 2 | feb | 200 |
2012 | 3 | mrt | 100 |
2012 | 4 | apr | 200 |
2012 | 5 | mei | -100 |
2012 | 6 | jun | 200 |
2012 | 7 | jul | 100 |
2012 | 8 | aug | 200 |
2012 | 9 | sep | -200 |
2012 | 10 | okt | 200 |
2012 | 11 | nov | 100 |
2012 | 12 | dec | 200 |
Furthermore, I created two formula fields.
Blockleft:
if {Sheet1_.amount}>0 then
replicatestring(chrw(110),abs({Sheet1_.amount}\10))
Blockright:
if {Sheet1_.amount}<=0 then
replicatestring(chrw(110),abs({Sheet1_.amount}\10))
- In the Details section I put the fields Blockright, Month, Blockleft.
- The fields Blockright and Blockleft I gave the font WingDings.
- Blockright should be right aligned and Blockleft left aligned.
- Blockright should get the color red; Blockleft the color green.
- I grouped on Year.
- The rows I colored alternating using the formula:
color(255,255,200)
else
color(255,200,255)
Reacties