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 (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
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 |
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)
So it's not possible without using dimensional package ?