8 Replies Latest reply on Nov 21, 2018 11:58 PM by ofir keren

    Presenting measures from calculated field without the attributes in that calculated field

    ofir keren

      Hi All,

       

      I need to create a report that consists of a list of measures per region ("Region" is a field in my data source), but each one of them is a result of a calculated field.

       

      Each calculated field has an IF statement that compares a certain attribute (for example: Category = 'XXX') and the result is a measure (for example: SUM(Sales)).

       

      The problem is that I don't want "Category" to be in my report, in other words, I don't want to put it on the Rows / Columns shelf.

       

      If I do put it, I get the right results back for my measures, but if I don't, I don't get anything back.

       

      Is there any way to solve this? Is there any workaround for this issue?

       

      Thanks in advance,

      Ofir