Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be you can create one text object and put it in top of that header with 'Layer' on top in the Layout Tab
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.
Can you show me how did you do this please?
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
I´ve done that, but I don´t know why after doing this, I see only the column 3, the others disappear
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
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.
I´ve tried already. and I don´t know why after doing this, I can only see the 3th column of my 3 dimensions
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])