8 Replies Latest reply: Apr 27, 2017 5:07 PM by Daniel Nuñez RSS

    Problem - Line of Reference

    Daniel Nuñez

      Hi Everyone,

       

      I actually have:

       

      Variables:

      1. Product (5 types of product)

      2. Customer (X Customers)

       

       

      Data:

      1. Sum of Sales

       

      I use this formula for the line of reference: $(formula) = Avg( {$} [Sales] )

       

      I would like add an line of reference where when I select one Product in special graph the line.

       

      However, when I select a Customer the line of reference still being the average for the Product. and no the average for the customer.

       

      Thank you