COGNOiSe.com - The IBM Cognos Community

Hi,

my requirement is like this.
Data          ID
2004Q1    1
2004Q2    1
2004Q3    1

2004Q4    2
2005Q1    2
2005Q2    2

How to achieve like this.

FYI: Data column is sample values.

thanks,
yogeswari.

Can you be more clear... no clue, what you are trying do? Why is the topic name calculation? Are trying to calculate some inbuilt function.

Thanks,
RK

First of all, Thanks for your reply

Actually my requirement is to display 3 quaters in a page.  To achieve that it is possible to do PAGE BREAK.

So i need one calculated column which should have similar values so that page break with that calculated column is possible to do so.


Any sugestions on this.  Please help me on this as i am searching for past 1 week :( :( :( :(

thanks,
yogeswari.

If you have a relational source you could look into running-count perhaps.

Thanks for your response,

running-count function will uniquely displaying numbers for each row
eg:
1
2
3
4
5...


but i need similar values for 3 rows
1
1
1
2
2
2
3
3
3

The range may change to 4 ...

Please give me an idea :) :) :)


thanks,
yogeswari.

You can divide running total by the desired group number and discard the remainder to use as the basis for your page break.


Sent from my iPhone using Tapatalk

Hi Yogi,

Try this,

Create a new data item has the expression as mod(running-count([Date]),3)

Then page break on that data item, so based on the number "3", "4" it will keep that in tact and break on the number of months.

Thanks,
RK

Thank you so much for all of your responses.

I too tried this logic before, but it will not suite my requirement because i need ONLY 3 rows/quarters has to be displayed in a single page.  (attaching screen shot for your references)

But applying this logic, it will give more than 3 records in a single page.
The series should be
1
1
1
2
2
2
3
3
3
4
4
4.....


Not like this.
0
1
2
0
1
2

Please give me an idea :( :( :( :( Finding very difficult to get.

thanks,
yogeswari.

How about

ceiling(running-count([Date])/3)

This is the exact approach Lynn suggested yesterday.

Cheers!

MF.

Million times thank you for ALL for your responses.

It is working.  Really you are GREAT!!!

Thank you so much :) :) :) :) :) :) :) :) :) :) :) :) :) :)

thanks,
yogeswari.