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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.