1. Create a List report with just one column Product Line
7. Select List Column Title --> select Box Type as None
8. Run the report --> You will see the report output like a section created on Product Line
2. Unlock the Lock
Symbol --> Insert another List
inside the List Column cell -->
Associate this List to Query1
3. Now, insert Product Type, Product Name and Revenue
columns as shown below
4. Right-Click on List2 and select Master Detail
Relationships
5. Create a link between Product Line columns as shown below
6. Apply formatting as shown below
7. Select List Column Title --> select Box Type as None
8. Run the report --> You will see the report output like a section created on Product Line
3 comments:
The article was very clear and it's usefull information Cognos Tm1 Online Training Hyderabad
Hello
I would like to know in cognos 11 the how to the ranking for a columns
eg:
percent value rank
0.968 50
0.967 49
0.966 48
0.965 47
0.964 46
0.643 upto 1
please help much appriciated
P0wer bi onlinetraining
P0wer bi training
Post a Comment