Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The message you are trying to access is permanently deleted.
Hi all,
I am using comparative analysis to do an ad hoc template for user to nagivate around. (Aka alternate state)
On the Script I have this code
_Dimension_PMX:
LOAD * INLINE [
_Dimension_PMX
Box
TEU
this means that if user check on TEU, the table will appear box on expression using conditional format
=SubStringCount(Concat(_Dimension_PMX, '|'), 'TEU')
and my expression to that conditional expression is
sum({[Group 1]}TEU)
However, for this report i woud like my expressions to have set analysis where Activity_Code = 'LOAD'. This is to cater a certain ad hoc template for this
meaning if is without alternative anaysis, it will be sum({<Activity_Code = {'LOAD'}>}TEU)
I would not want user to select Load activity code everytime as it defeat the purpose
thanks!
anybody.....
Please Try Following
Conditional
=SubStringCount(Concat(_Dimension_PMX,','),'TEU')>=1
And expression
sum({[Group 1]}TEU)
i think this is not the answer that i am looking for. I am able to do comparative analysis
say if the user select some selection and the TEU is 200, out of these 200, on activity_code = LOAD, it only containes 80. Therefor, my expression would want to show 80 instead of 200. I must put Activity _Code - load on the expression.
sum({<Activity_Code = {'LOAD'}>}TEU) plus comparative analysis of sum(Group 1 teu)
Thanks
sum({Group1<Activity_Code = {'LOAD'}>}TEU)
Please try this.
Vikas
thanks!
PFA Sample
Vikas