Problem - Line of Reference

[#1]

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

[alextimofeyev]

Daniel,

what dimension(s) does your chart have?

[#3]

HI Alex,

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

Graphically:

[alextimofeyev]

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?

[#5]

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

[alextimofeyev]

What if you have several products selected?

[#7]

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.

[alextimofeyev]

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

Avg({$<Customer=>} Sales)

[#9]

Thank you. It was what I need.