Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team
Basically my requirement is to get the bucket/interval of values on x-axis based on user input. If usre enters 10. then the x-axis should display 0-10,10-20,20-30,30-40,etc.
For this, I am using class function in dimension.
The expression is like:
=Class((Sum([Total net sales USD])/$(vActualVolume_UoM)),vL.BandWidth)
But this expression is not working in calculated dimension.Dimension:=Class((Sum([Total net sales USD])/$(vActualVolume_UoM)),vL.BandWidth)
Expression: =$(vActualVolume_UoM)
Variables:
vActualVolume_UoM: is calculated volume based on user selection. There are 2 types of Volume which user can select based on the selection value will be stored in the variable.
vL.BandWidth: User input number like 1,2,3,4,5,etc.
Thanks in Advance!
Hi
try this
Class(([Total net sales USD]/$(vActualVolume_UoM)),vL.BandWidth)
Or
Class((Aggr(Sum([Total net sales USD]), Dimension Field )/$(vActualVolume_UoM)),vL.BandWidth)
Regards
Raman