How to show the trends of products?

[#1]

Hi,

I have Line chart with below items

Dimension1 : =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)

Dimension2: Productname

Expression: Count(DISTINCT {$<DateType={'EnterDate'},Fromcolumn={'0'},Flag={2}>} ProductID)

I would need to show the trends of Products each week. How can I get this can anyone help me.

Thanks.

[SunilChauhan]

Dimension 1

and Dimension2  in dimension i.e first take dimension1 and then dimension 2

and expression in expression

product should appear as legends

hope this helps

[pover]

Hi Amelia,

How you have it should show you the trends of products for each week.  Is the line chart not showing anything or showing something incorrect?

Karl

[#4]

Thanks and please can you make it a bit more clear.

[#5]

Thanks. The values are correct but I need to show the count of moving trend line of products each week

[pover]

So you have a table now and you want to make it a line chart?

[#7]

No, I have line chart. In that line chart I need to show the trends. Is it possible?

[pover]

What do you mean by trends?  Line charts by themselves show trends.

[#9]

Thanks. I need like attached. May be is it possible with Bar Chart. Is that correct?

[aveeeeeee7en]

Hi Amelia

See the Attached.

If found helpful than just add your expression in the Chart by replacing it.

Regards

Aviral Nag