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

Problem - Line of Reference

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

• Re: Problem - Line of Reference

Daniel,

what dimension(s) does your chart have?

• Re: Problem - Line of Reference

HI Alex,

Dimension are months: Like: January, February ....

Graphically:

• Re: Problem - Line of Reference

Can you help me understand, what should the line represent? The average monthly sales of selected products (or all, if none are selected) among X customers?

• Re: Problem - Line of Reference

Hi,

Line represent: the average of sum of sales for 1 product. But if I select one customer the line change but I need the average for all customers in the black line.

Thanks

• Re: Problem - Line of Reference

What if you have several products selected?

• Re: Problem - Line of Reference

In this moment I don´t like several products only one. But this have a lot of customers.

I would like analize a customer month by month with the average of sales in total sales for all customers.

• Re: Problem - Line of Reference

OK, if I understand your need correctly, you should try

Avg({\$<Customer=>} Sales)

• Re: Problem - Line of Reference

Thank you. It was what I need.