5 Replies Latest reply: Feb 25, 2015 1:16 PM by Saradhi Balla RSS

    Expressions loaded in inline table

    Maria Roussaki

      Hello everyone,

       

      I am creating a report where I am using the same sales expressions in many different tables.

      I am loading an inline table with those expressions written in it as following:

       

      What I don't know is how to actually proceed after that, in order to use those expressions in my pivots.

       

      I have tested them separately, for example if I write in my pivot the expression

      =SUM({$<MTD_Flag={1}>} Unit_Sales)

      it gives the correct results.

       

      What I want to do is retrieve the expression just by using the Pivot_Expr field name, so by switching between the Units and Net Sales or the different periods, I can automatically have the right results. Another reason for this is that those expressions are used in many places in my layout tables, so I would like to have them all in one place, for better future support.

       

      I have tried writing as an expression in my pivot the $(=Pivot_Expr) but it doesn't give any results.

       

      Could someone please help me with this?

      Thanks in advance for your time

       

      Best Regards,

      Maria.