How to apply PRE_FILTER in LAC to impact only few columns, I want to exclude 2 columns from the prefilter. is there a way to do so.
For example: sumover(Numbers, [G1, G2], PRE_FILTER)
But I want to exclude column G3 which is also getting impacted by the Prefilter.
Hi @Dhriman
You can use “ifelse” expression conditions and apply selective filter conditions while calculating LAC at the PRE FILTER level .
Remove the visual level filter on G3 instead define a parameter with control on G3 field values.
sumover(
(ifelse( G3 = $PARAMETER , Numbers,0 )),
[G1, G2], PRE_FILTER)
Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”.
This will help the community to find guidance and answers to similar question. Thank you!
Thanks
Vinod