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
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
sample.qvw 135.0 K