Text only
|
Text with Images
COGNOiSe.com - The IBM Cognos Community
IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: andisu on 21 Jan 2014 06:37:34 AM
Title:
Drill trough lines
Post by:
andisu
on
21 Jan 2014 06:37:34 AM
Hello i have a table like this
TABLE
SON
FATHER
VALUE
1
1
500,00
2
1
200,00
3
1
300,00
4
2
100,00
5
5
400,00
and i need to do an report like this
Report:
Reg
Total Value
1
1100,00 (sum(sons 1,2,3,4))
2
300,00 (sum(sons 2,4))
3
300,00 sum son 3
4
100,00 sum son 4
5
400,00 sum son 5
But i have no idea how can i join the lines, cause i have an variable number of sons and fathers like a tree. Can you help me?
Thanks!
Title:
Re: Drill trough lines
Post by:
adik
on
22 Jan 2014 12:51:48 AM
you will havet use analytical functions like this:
total(value for father)
Text only
|
Text with Images