Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
I have created Buckets with 0-3 Months, 3-6 Months,9-6 Months & So on...
I have the Total QTY--30 as per the aging concept it was distributed in the buckets, and also I need to See Total QTY as 30 also in the One Column in Pivot Table...
Regards,
Helen
Provide Sample Data Please...
You can try with ValueList Function.....
Hi,
You can use the class function below is from QV help
class(expression, interval [ , label [ , offset ]])
Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.
Examples:
class( var,10 ) with var = 23 returns '20<=x<30'
class( var,5,'value' ) with var = 23 returns '20<= value <25'
class( var,10,'x',5 ) with var = 23 returns '15<=x<25'
Regards
Anand
I have already created Buckets based on QTY...
The thing is I need to See total QTY which has bifurcted among buckets...
Hi Helen,
does this question refer to the sample application you posted here:
wherein you are using a calculated dimension I proposed in this thread:
which you refused to close stating your initial question has not been answered?
thanks
regards
Marco