Hello,
Is there any way to identify a particular node member value of a cross tab?
Let us say my cross tab horizontally shows the fund names and vertically (column wise) show the years from x to 2025 based on years in database, is there any way (function) to check if for 2016 my fund A's measure value is null or not?
I need to hide a particular row for a fund if it' s measure for the year selected (via prompt) is null.
Thanks,
Quote from: asmfloyd on 06 Feb 2019 01:03:08 PM
Hello,
Is there any way to identify a particular node member value of a cross tab?
Let us say my cross tab horizontally shows the fund names and vertically (column wise) show the years from x to 2025 based on years in database, is there any way (function) to check if for 2016 my fund A's measure value is null or not?
I need to hide a particular row for a fund if it' s measure for the year selected (via prompt) is null.
Thanks,
Hi,
You can use a filter() function with a tuple() in the expression for the row edge to achieve this. Something like:
Filter([your Year level], tuple(?your Year member parameter?,[your Fund A member], [your measure value]) is not null)
Cheers!
MF.