Ranking and Break on Same Block

building reports webintelligence
1

Hi All,

I’m facing some issue in applying Break on a column as I’ve already applied Ranking on that Block. For more details follow the case below.

Case: eFashion Universe
Drag Lines, Year, Sales revenue into the result object pane.
select lines, apply ranking top 3 lines based on Sales revenue for each Lines.

Now if i select year and apply break on it it gives me values which i can get on unchecking the for each Lines option from the Ranking but i want to see the result in the following format. See the attached Excel for format.

Can someone suggest me how to do it? I’m getting the desired output in Sections format but i want it to be in the simple table format.

Any help would be deeply appreciated.

Cheers,
Breaks and Ranks.xls (20.0 KB)

shiva.tomar (BOB member since 2007-10-05)

2

Highlight the Year column. On the properties tab in the left pane, unselect the “Show Break Header” and “Show break footer” options from the “Breaks” section .

Then from under “Display” section , check “Show table headers”

This should give you result in one table.

rimpa :india: (BOB member since 2008-04-14)

3

Thanks Rimpa.

It worked. :smiley:

Regards,

shiva.tomar (BOB member since 2007-10-05)