3 Replies Latest reply: Sep 12, 2017 6:07 AM by Dermot mcgoldrick RSS

    Using Variable In Straight Table

    Dermot mcgoldrick

      I have a simple variable, vKPI.Backlog.#Lines,  that allows me to count total lines :

       

      =count({<KPI = {'Backlog'}>}Order_ID)

       

      And as a total count this works fine.  When I use this in a straight table using customer as dimension and the following as the exp:

       

      $(=vKPI.Backlog.#Lines)

       

      I get the overall total for all customers against each customer.  Is it not possible to use a variable like this in a straight table?