Can I use column(columnNO) in set analysis?

[#1]

Can I use column(columnNO) in set analysis?

For example {<DATE = {'<= column(4)'}>} ??

[pover]

After a simple test, this does not seem possible. That does not surprise me since set analysis does not respect the dimension values in a chart either since it is calculated before the expression is calculated for each dimension value. Use a sum(if()) instead.

Regards.

[#3]

I am suprised that columnNo() is not working in set analysis because rowNo() works out just fine.

[gchavez]

how would be to use sum( if() )?

[mansoorsheraz]

Hi @pover ,

Even after 13 years of your posting, this is still helpful today. I was looking for a similar issue and got it resolved exactly as you mentioned in just seconds.

Thanks a lot.

Regards.

[mansoorsheraz]

You may use it like this :

=Sum(if(<your_dimension_1>=<your_dimension_2>, [<your_value_dimension>]))

Hope this helps.