Hello there,After trying multiple combinations of these if statements, I can't wrap my head around it to get it working properly. I'll try to lay out ...
After trying multiple combinations of these if statements, I can't wrap my head around it to get it working properly. I'll try to lay out the problem as best as I can so that you guys can help me out - hopefully:
I have this layed out on a pivot table and the need is to handle the dimension so that the table shows:
01 - N/A, because these 'lines' are to be there independent upon the type of discount chosen;
02 - The lines that relate to the SelectionType.
I have been trying the following, but without success as it doesn't hide the rows not related to the SelectionType. It keeps showing everything:
=if(Description = 'Expenses',
if( not '$(vExpandDesp)' = 'Expenses', null(), Description),//This is for a couple of lines that expand or collapse depending on another variable
if(SelectionType = 'N/A', Description,//This is to keep 'N/A' unhidden
if(SelectionType = vSelectionVar, Description, null())))//This is to show only rows that meet the variable criteria
Appreciate your time.