11 Replies Latest reply: Jan 5, 2013 3:25 AM by jagan mohan rao appala

# top 5 values in pivote table expressions

Dear all,

I have the dimensions like  Region,Location,desigation for this i need the top 5 counts.

if any one having soluation pls let me know

• ###### Re: top 5 values in pivote table expressions

hi

what's you want in top 5

• ###### Re: top 5 values in pivote table expressions

Hi,

You can try this.

sum({<Customer={"=rank(sum(Sales))<=\$(=vTop)"}>} Sales)

Where set vTop=5 in variable, so that it will give you correct result. In place of customer add ur dimension which u want.

Regards,

Nirav Bhimani

• ###### Re: top 5 values in pivote table expressions

hear i am having more dimensions in pivote table.......

• ###### Re: top 5 values in pivote table expressions

HI,

I need the Count of Employee-id is the top 1 values.

year,location,desigation ,  Count(Empid)[Expression]

2012,dd,dsddf,                    35

20

19

12

8

like wise i need for each and every year,Location and desigarion wise need yar .please help me out.

• ###### Re: top 5 values in pivote table expressions

HI,

Try this,

AGGR ( sum({<Customer={"=rank(sum(Sales))<=\$(=vTop)"}>} Sales), year,location,desigation)

Regards,

Nirav Bhimani

• ###### Re: top 5 values in pivote table expressions

I need the top 5 high count value . not sume values. yar.

• ###### Re: top 5 values in pivote table expressions

Hi,

Try this expression

=If(AGGR (rank(sum(Sales)), Customer) <=5 , Customer)

in dimension.

Regards,

Jagan.

• ###### Re: top 5 values in pivote table expressions

top 5 Employee count

• ###### Re: top 5 values in pivote table expressions

top 5 employee

• ###### Re: top 5 values in pivote table expressions

If u r using 11 version u have dimension limits tab, there u can select ur dimension on which u want to restrict,

u have differen options on that tab top, bottom, large.... like this

• ###### Re: top 5 values in pivote table expressions

location and year wise top 5 Employee count  ...............required pls help me out this