Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Filter selection not working to Set Analysis Condition.
=Avg({$<[BP Repair Type]={'Heavy','Medium'},[BP Lead Time DEX] ={"<100"}>} [BP Lead Time DEX]) + Avg({$<[BP Repair Type]={'Super Light','Light','Grooming'},[BP Lead Time DEX] ={"<50"}>} [BP Lead Time DEX])
Filter is
BP Repair Type |
Grooming |
Heavy |
Light |
Medium |
Super Light |
Thanks
Vinod.
What are you trying to do?
Your set expressions are created in such a way that any selection to <[BP Repair Type] will be ignored.
Please Suggest How to write the expression which has to be change based on the Filter selection.
How should it affect your expression?
=Avg({$<[BP Repair Type]={'Heavy','Medium'},[BP Lead Time DEX] ={"<100"}>} [BP Lead Time DEX]) + Avg({$<[BP Repair Type]={'Super Light','Light','Grooming'},[BP Lead Time DEX] ={"<50"}>} [BP Lead Time DEX])
What should happen when selecting 'Heavy' and 'Light' or when you're only selecting 'Grooming'?
You could try this adjustment? It will only calculate for the selected repair types that intersect with your modifiers.
=Avg({$<[BP Repair Type] *= {'Heavy','Medium'},[BP Lead Time DEX] ={"<100"}>} [BP Lead Time DEX]) + Avg({$<[BP Repair Type] *= {'Super Light','Light','Grooming'},[BP Lead Time DEX] ={"<50"}>} [BP Lead Time DEX])
Is this what you are looking for?
I am trying to find out the Average of [BP Lead Time DEX] for [BP Repair Type]-->Heavy and Medium and [BP Lead Time DEX] less than 100 for Heavy and Medium same
for [BP Repair Type] -Super Light, Light, Grooming and [BP Lead Time DEX] less than 50 for Super Light, Light, Grooming,
If i Select [BP Repair Type] filter it should change accordingly.
>>If i Select [BP Repair Type] filter it should change accordingly.
That's the $64k question.... If Vegar's solution is not working for you, then you need to be more specific about what should happen the selections that you might make. Is should change precisely how?