Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all
i can create two varible Vupperlimit,Vlowerlimit
user have to enter the range through input box lowerlimit upperlimit
1 6
the data should in the range only in any table.
Hi,
We can do this through Dimension Limits in a property page.
Hi,
Please check attached file.
Hi
Try like this
=Sum({<ID={">=$(=vLowerLimit)<=$(=vUpperLimit)"}>}Sales)
I used the csv file attached.
Created variables vLowerLimit and vUpperLimit.
Created input box & added those variables.
Created Straight table using ID as dimension
Expression as =Sum({<ID={">=$(vLowerLimit)<=$(vUpperLimit)"}>} Sales)
It works for me.
Also for selected field based report check this link
and see the reports tab. Same file you can find in ur installation path.