Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 the problem as best as I can so that you guys can help me out - hopefully:
Data Table:
SelectionType | Description |
N/A | Bonus |
N/A | Bonus Unit |
SimpleDescount | SalesSD |
SimpleDiscount | MarginSD |
DiscountReav | SalesDR |
DiscountReav | MarginDR |
TotalDiscount | SalesTD |
TotalDiscount | MarginTD |
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.
After double checking backwards, I found out that the there was a flaw when creating the SelectionType column in a way that there'd be duplicates for some of the Description rows.
It may sound such a basic mistake, but this also takes a lot of time (for beginners like me), where we are looking at the problem from a perspective, while the origin of the issue is somewhere else.
Cheers,
It might be easy if you are able to share a sample where we can see the issue.
Hello @sunny_talwar !
I've actually found out why this wasn't working.
There was a flaw when creating the SelectionType column in a way that there'd be duplicates for some of the Description rows. Fixed it.
Not sure if I should mark it as solved, through, or just delete it.
Cheers,
Antonio
Mark your own response as the correct answer
I'll do that, but it may seem misleading...as if I'm creating an issue to be the savior! Cheers!
After double checking backwards, I found out that the there was a flaw when creating the SelectionType column in a way that there'd be duplicates for some of the Description rows.
It may sound such a basic mistake, but this also takes a lot of time (for beginners like me), where we are looking at the problem from a perspective, while the origin of the issue is somewhere else.
Cheers,