Hi,
In my pivot table, I have the following expression as my lowest-level dimension (Dim3) to filter Dim3 by measure >= 50.
Do I need to apply this filter by making my measures expressions in my pivot table? Asking because I'm noticing my Amt1 + Amt2 measures are still including all values.
Does this question make sense? I did try to search the forum for similar questions but didn't find this particular question online.
Dim3:
If(AGGR(SUM(Amt1)+SUM(Amt2), Dim1, Dim2, Dim3)< 50,NULL(),Dim3)
Measure1 - instead of below, should this be an expression similar to above?
Sum(Amt1)
Thanks