Identifying Node value of a cross tab

[asmfloyd]

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,

[MFGF]

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.