Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a filter where the field is =MonthName(SomeDateField).
How do I ignore this filter selection in an expression?
This doesn't work:
=Sum({$<SomeDateField=>} [ColumnA])/Sum({$<SomeDateField=>} [ColumnB])
If I change $ to 1 it works but it also ignores all the other filters, which I don't want.
Thanks in advance,
Dan
Hi, you really don't need a set analysis in your case.
An expression like this will disregard all other dimensions except those listed i.e. Dim1, Dim2 and Dim3
Sum(TOTAL <Dim1, Dim2, Dim3> [ColumnA]) / Sum(TOTAL <Dim1, Dim2, Dim3> [ColumnB])
Try creating a field in your script using MonthName(SomeDateField) and then use this field to disregard the selection