Need to get particular records?

[rathnam_qv]

Hi All,

I have some millions of records.

I want to create 3 pivot tales ...

1st table with top7 (1,2,3,4,5,6,7)suppliers (my dimension is Supplier)

2nd table with top8-14(8,9,10,11,12,13,14) Suppliers

3rd---top15-21(15,16,17,18,19,20,21) suppliers.

Can anyone help me out.

Thanks,

Muni.

[rathnam_qv]

Hi Manish,

SUM({<Customer = {"=Rank(SUM(Sales),4)<=14 and  Rank(SUM(Sales),4)>7 "}>}Sales)

in the expression SUM(Sales),4)---what is 4 ?

can u please explain me?

[rathnam_qv]

ok Manish,...i got it.

Thanks you for ur help.

[Chanty4u]

coooooooool

if u got the correct answer  Please close the thread by making correct and helpful answers above