3 Replies Latest reply: Feb 25, 2016 11:35 AM by Stefan Wühl RSS

    Straight Table Set Analysis Question

    George Barrett

      I have a straight table with multiple columns of dimensions and one column of an measure. The measure is simply an ID field with no aggregation, but a color expression. I have a field named CurrentFlag that I would like to use in set analysis. I only want to display rows where the CurrentFlag field value is 1. I tried adding set analysis to the expression like so: {<CurrentFlag={'1'}>}ID. However, this results in an error. Looking at another post I tried using: Only({<CurrentFlag={'1'}>}ID), which didn't result in an error, but it only hid the ID numbers and not the entire rows. Does anyone have a solution to hide the entire row if the flag is not 1? This must be handled in the front end.

       

      Thanks.