Progressive chart

[Fuigi]

Hi,

I created a progressive chart with total column at the end with display summary colomn. But I want to have this summary colomn after all the end of my month.

Cause my progressive chart is made by month and by product, after all product is displayed we pass to the next month, here I want a summary colomn.

as on that http://www.waterfall-chart.com/Content/turnover-contribution-waterfall-chart-for-excel.png
Can I do that ? And how if you know

I use Cognos 10.1

[rockytopmark]

Is the package this report is based on Dimensional? (Cube, DMR, etc)

If so, you might want to try formulating a single data item that returns the members from multiple levels of the hierarchy... using the Union() function.

union(children(currentMember(<hierarchy>)), set(<parent member level>))

Member	measure
child1	-200
child2	100
child3	300
parent1	200

[Fuigi]

I use a connection to my database and extract data with "Code SQL".

So no dimensional. (sorry I'm new and I don't understand Cognos well)

[Fuigi]

So it's not possible without using dimensional package ?