One Dimension value static & other variable in TOP analysis

yuvraj_33 — Thu, 12 Nov 2015 13:08:29 GMT

Hi All,

I have this query wherein I need to implement a top 5 analysis in bar chart where one value is static & others vary as per selections.

e.g.: Suppose I have 10 materials as follows.

-----------------------------------------

Material | Sale

-----------------------------------------

Pen - 40

Pencil - 30

Eraser - 60

Sharpener - 70

Colors - 50

Palette - 10

Notebook - 20

Textbook - 100

Brush - 80

Compass - 90

-----------------------------------------

I need to show top 5 Sale for Materials as Colors + Top 5 which makes overall 6 values.

Here, Material = 'Colors' should be constant & Top 5 from remaining 9 materials.

So, as per requirement the output should be in following sequence in a bar chart:

1. Colors - 50

2. Textbook - 100

3. Compass - 90

4. Brush - 80

5. Sharpener - 70

6. Eraser - 60

Please suggest over the same.

Re: One Dimension value static & other variable in TOP analysis

swuehl — Thu, 12 Nov 2015 13:34:35 GMT

Dimension: Material

Expression:

=Sum({<Material = {'Colors'} +{"=Rank(Sum({<Material -= {'Colors'}>} SaleField))<=5"} >} SaleField)

yuvraj_33 — Thu, 12 Nov 2015 13:50:40 GMT

Thank you swuehl, its working...