Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
you use dimensionality() function.
if(dimensionality()=1, ExpressionTobe display , Actual Expression)
What is the additional value you need to display ??
can you explain with the example
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
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
try like this
if(dimensionality()=1, num(your_expression,'###0.0') , your_expression)
If(dimensionality() =1, round(sum(value),0.01),round(sum(value)))
Or
If(dimensionality() =1, sum(value)&'something',sum(value))