Problem with total value

[#1]

Hi All

I Have problem with the total value for this type of dimension:

In this picture :

X : Main Value

Y : Count Value

Z : X/Y

How can I hav total value for Z value??

tnx All

Atefeh

[#2]

This is the result

beacause i have differnet value for "Y"

I want total for "Z"

[#3]

hi

go to properties of chart ---- > presentation ---> select field then check on show patial sum

now if Z is take as dimension then sum automatically show.

if Z take as expression then in your expression write  sum(Z)  or sum(total(Z)) .

thanks.

[#4]

Hi,

U need to write expression like below

Z:   sum(X/Y)

go to properties of chart ---- > presentation ---> select field(Z) then check on show patial sum

Regards,

Kabilan K

[#5]

Thanks Kabilan K

Sorry for this delay

sum(x/y) is not true,Caz:

Result: sum(X1+X2+X3...)/sum(Y1+Y2+Y3+....)

but i need this result :  sum((x1/y1)+(x2/y2)+(X3/Y3)+.....)

plz help me on this

[wizardo]

HI

what you ask for is "sum of rows".

this can be simply done in a striaght table where you can change the "total mode" of the expression from "expressions Total" to "sum of rows"

a pivot table allways uses "expressions Total"

to do what yu need in a pivot table it is only posible  by the use of the AGGR() function

the aggr functions take an expression as its main paramter and one or more dimensions as its other paramters

and reuren a set of values from the expr aggregated over the dimensions.

and then you can use SUM() to aggregate these values

what you need to do is use:

sum(aggr(sum(x/y) , yourdimension1,yourdimension2,yourdimension3))

since you have more then one dimension in yoru sample

you can use the

Dimensionality ( )  and Secondarydimensionality ( ) functions to

determine what level of the pivot is open and use an if expressions to set the expression with the relevent dimesnions

hope that helps

Wizardo

[#7]

Tnx Wizardo

But That s not true

I want total value to use in the bar chart

but the value is not correct

please check my sample ,

maybe it can helpp you

[wizardo · Accepted solution]

HI again

im sorry i was using X and Y as abstract example

when you use the aggr function you cannot use Column names that comes for the column names in the chart

you must use the actual names of the fields you are summing

like this

SUM(AGGR(SUM(Sale/Count),Year, Month,Branch,Type))

[#9]

Completely True

Thanks alotttttttttttttt