Show one dimension value in a column table chart

[#1]

Hi,

Is there anyone who knows how to display just one centered value in the dimension column of a table chart when this dimension just have one value.

Let's see my example below :

In the first column, I want the value "NIE" to be centered and to appear just one time.

I also want to delete the total row. How can I do that ???

Thx for your help.

+++

Nicolas LE ROUX

[prieper]

Totals can be switched on/off in the tab with the expressions ("Total Mode") on the mid right; alignment of dimension can be changed under "Presentation".

HTH
Peter

[Miguel_Angel_Baeyens]

Hello Nicolas,

You'd better use a pivot table chart instead of what it seems to me a straight table.

Regarding the totals, go to the chart Properties, Presentation tab, and uncheck "Show Partial Sums" for all dimensions. On the right side of that dialog, you will see the "Alignment" buttons to display labels and values centered.

Hope this helps.

[#4]

Instead of straight table use pivot table with the option "Always Fully Expanded". ( Properties -> Presentation ->Always Fully Expanded)

[#5]

OK, thx for your help.

I'm gonna try everything.

Bye