7 Replies Latest reply: Sep 21, 2016 2:24 AM by x mg

# rank,aggr,dynamic dimension  in a chart

Hi,

Everyone,I met a problem in below pic:

When I make a choose '2' with yellow color in the char "SelectBoard",then four CustID appear, not the correct number '2'

The corrent appearance is like below,

So could anyone know the reason or a solution? !

• ###### Re: rank,aggr,dynamic dimension  in a chart

When you 'select' a value in an expression cell then you don't select that expression value, but you select all the dimension values used to calculate the expression value. That's one reason why you get that selection you see. There's no solution for that. You cannot select expression values.

• ###### Re: rank,aggr,dynamic dimension  in a chart

thanks for your reply, but I donnot think so.  You may take a test  :  remove the rank function,then it works.

So,I think  RANK function is the reason, that it doesn't support the Pivot table enough.

• ###### Re: rank,aggr,dynamic dimension  in a chart

If you make selections in a chart, you are basically selecting in the dimension values your grid cell is grouped by.

In your case, you are using calculated dimensions based on CustID, hence you are making selections in CustID (even if you don't see it in the chart, since you are also using set analysis to ignore CustID selections.

Create a list box for CustID and you will see the effect when selecting in your chart cell.

• ###### Re: rank,aggr,dynamic dimension  in a chart

Because, You have association with All CustID, See this Image

This Case, If you want to show same as your Graph, you can use this

Year1 Expression             sum({<Year1, CustID={'C002','C005'}>}QTY)

Year2 Expression             sum({<Year2, CustID={'C002','C005'}>}QTY)

Now, Image looks like this

• ###### Re: rank,aggr,dynamic dimension  in a chart

thanks for your reply, but it's not the meaning with this case. Here is a dynamic dimensions chart, so ,your expression isn't suitable .

• ###### Re: rank,aggr,dynamic dimension  in a chart

Yes, Graphs will effect based from Data Model and Associative only, Have you seen the first image, You are selected two years then associative to All CustID. Would you explain more what you want to achieve so that we will show you different menthod

• ###### Re: rank,aggr,dynamic dimension  in a chart

In the SelectBoard, Here means Levels change between two periods