Condition to bring 2 trendlines?

[#1]

Hi,

Please find the attached image file and excel.

I am having 2 products named X and Z in my excel.

and the values i am using are for the trend line is sum(TEB).

This [sum(if(date>= date(today()-91), TEB))] expression helped me to get the 13 weeks data for sum of both X and Z.

For the same query, I want to display 2 trendlines for X and Z.

How do i get this? Do I have to try with a if condition? (I want to keep this query also [sum(if(date>= date(today()-91), TEB))] in the condition.

Thanks in advance.

[#2]

Hi,

what about using ProductName as the second Dimension ?

Roland

[#3]

My apologize. I had taken a wrong excel to pull the data.

I got the dimension now.

Thank you Roland.