Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ranking on Cross tab report in BO webi

Status
Not open for further replies.

harshalsoft

IS-IT--Management
Jul 17, 2016
3
US
Please help very urgent
 
I am looking for ranking over cross tab but finding many issues with that

Requirement is

Looking
GROUP BY COLUMN
Percentage(on date1) date1(current_Month) Date2
GRP(TOTL) A 100% 50 10
SUBGP a1 20% 10 2
a2 40 20 3
a3 60 30 5

B 100% 9 5
b1 22% 2 1
b2 33% 3 2
b3 44% 4 2

Percentage(on date1) column added by right click on column group column A which is made up of variables. when i rank on percentage column say top1 it works fine on

Percentage(on date1) column but not in main cross table column date1(current_Month) & Date2

those values gets disappeared and when added no filter clause it reappears but total sum on group is getting summed up on all recordcs

expected output

Percentage(on date1) date1(current_Month) Date2
GRP(TOTL) A 60% 30 5
a3 60 30 5

B 44% 4 2
b3 44% 4 2
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top