Skip to Content
Former Member
May 27, 2013 at 08:59 AM

Data manipulation for chart display


Hello Experts,

Hierarchial Output from Bex query would be like below, based on node selections by user rows may vary maximum 10 rows.

Nodes first row last row graph value

Overall result 1.0 10.00 xx

a xx xx 1

b xx xx 2

[-] cd xx xx 3

c xx xx 1

d xx xx 2

xx- represent some numbers...

I need to manipulate the datasat in the below format in a way it can be used for charting (not for display purpose) - we use 3d graphics- waterfall chart

first row 1.0

a 1.0

b 2.0

[-]cd 3.0

c 1.0

d 2.0

last row 10.0

I just replaced the "overall result" with "First row" value. what i need here is to create a dummy row somehow and assign the last row value.

Is there a way in CR to do so.. Please provide your inputs..

Note: Based on the node selection the number of rows will vary.