How to set a filter on variable

building reports desktopintelligence
1

Hi,

this is my first post and i hope anyone can help me.

In my table i have follow situation:

DossNr. | Name | Status 1 | Status 2

2776 TEST1 0 33
2776 TEST1 33 49
2776 TEST2 0 34
…

I would like to hide the entries, if Status 2 and Status 1 (next entry) are the same.

I create a Measure Variable(status3) with IF Previous(Status 2) = Status 1 Then “yes”

And now, i would like to hide alle entries with Status 3 = yes

How can i do that ?

Thanks a lot

Best regards,
Marcus

mdawideit :de: (BOB member since 2011-01-27)

2

Hi and Welcome to B :mrgreen: B

What you will need to do is make sure that you save your formula for status 3 as an actual variable. You can then apply a filter to that object.
With that object still in the table, you should now be able to click on the Filter funnel, or you can click Insert → Filters, then apply the value to restrict, in your case ‘Yes’
Lastly if you want you can hide this column by right clicking the table, select format table, select the pivot tab, highlight your status 3 object and click hide.

plessiusa :netherlands: (BOB member since 2004-03-22)