Help in visualization with Rank and Pick

[rcandeo]

I have this application where I see fixed calculations using set analysis for a selected client.

My problem is that I need to put client name on the top, instead of 3 dimension numbers used to format.

Something like this:

                                        NAME

               Ranking     Rank Change     Premium & Change

Overall          10                    5                         20%

Insurance       8                     0                         13%

Binding          25                   18                       -15%

Anyone can give me a hint please?

[settu_periasamy]

May be you can create one text object and put it in top of that header with 'Layer' on top in the Layout Tab

[vishsaggi]

I am not sure if you are looking something like this ? Let me know will this suffice your request if not use Sethu's tip.

[rcandeo]

Can you show me how did you do this please?

[crusader_]

Drag and drop in Pivot table. Pick the field and move it to top-right until Blue arrow become horizontal then drop it.

Hope this helps.

/Andrei

[rcandeo]

I´ve done that, but I don´t know why after doing this, I see only the column 3, the others disappear

[effinty2112]

Hi Robson,

                         In your pivot table add customer as a dimension and drag it to the top of the chart until the blue arrow goes horizontal then release the mouse button.

In the presentation tab select Customer in the Dimensions and Expressions list then select centre alignment for Data(Text).

Cheers

Andrew

[vishsaggi]

I have done nothing, just added Name in the  caption with Right alignment and unchecked the special icons in caption tab. This is just a work around. There might be some other way, which i am not sure. But if it suffice your requirment yes you can use this way.

[rcandeo]

I´ve tried already. and I don´t know why after doing this, I can only see the 3th column of my 3 dimensions

[sunny_talwar]

Check the attached out....

I have only fixed the 1st two expressions, you can implement the same change to others

Aggr(YourExpression, Dim, [Broker Group Name])