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:




      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?