summary rows must display value other than expression total

[#1]

hi

I have 1 dimension say city. and one measure say  weeklyavg of population in a pivot table.

when we go to presentation and clik on dimensions, partial sum option is available. it will display the summary of expressions. here I wanted another value to be  displayed other than expression total.

Is there any way?

[Kushal_Chawda]

you use dimensionality() function.

if(dimensionality()=1, ExpressionTobe display , Actual Expression)

[avinashelite]

What is the additional value you need to display ??

can you explain with the example

[#4]

u r close .

say suppose the display is as follows in pivot chart:

total             52

newyork      52

Atlanta         52

now, I wanted total to be displayed as 52.5(i.e 52.something)

actually the values are fixed to be displayed as numbers but I want the total to be displayed as decimals

[#5]

u r close .

say suppose the display is as follows in pivot chart:

total             52

newyork      52

Atlanta         52

now, I wanted total to be displayed as 52.5(i.e 52.something)

actually the values are fixed to be displayed as numbers but I want the total to be displayed as decimals

[avinashelite]

try like this

if(dimensionality()=1, num(your_expression,'###0.0') ,  your_expression)

[Kushal_Chawda]

If(dimensionality() =1, round(sum(value),0.01),round(sum(value)))

Or

If(dimensionality() =1, sum(value)&'something',sum(value))