Problem in using set analysis

[#1]

Hi,

     I have to show the top 5 Customers based on the Sales.I wanted to show them using a Pie Chart.

    Now this should be insensitive to any selections being made in the Listboxes(i.e..Fields)

    So I put the following Expression : If(Rank(Sum({1} Sales))<=5,Sum({1} Sales)) and Dimension:Customer

    This Expression populated the top 5 correctly.But what I need is:

    I have a Year Field and a Quarter field and the top 5 should change based on only the Year and the Quarter Selection.

    Please let me know the way forward.

Regards

Navin.G

[kaushiknsolanki]

Hi,

    Do you mean to say that the expression should be effected only for Year and Quarter filters..?

    If yes then you need to pass all other filters in set analysis. Something like this.

    Say you have 5 filers. i.e Field1, Field2 , Field3, Year and Quarter.

    If(Rank(Sum({<Field1 =, Field2 =, Field3 = >} Sales))<=5,Sum({Field1 =, Field2 =, Field3 =} Sales))

Regards,

Kaushik Solanki  

[#3]

Hi Kaushik,

                 Your right.I was able to now do it.I have another question

                  I have displayed the Top 5 in this way and now I need to display the Bottom 5 in the Same way.

                  Can you suggest any method to do so?

Regards

Navin.G