7 Replies Latest reply: Nov 15, 2017 1:28 AM by P M

# Values to repeat in a chart straight table

Hi

I want a value to be repeat in a column.  So in my table below, I want for the value for Min Month (ie Aug 16) which is 6 092 970 to be repeated in another column. (See 2nd table below for ideal answer).

For simplicity, My dimension is Calendar Month and my Expression is Sum(Sales).

Please note that Min Month is dynamic and not specifically relating to Aug 16

Kind regards

Nayan

 CalendarMonth Sales Aug-16 6 092 970 Sep-16 6 862 879 Oct-16 6 530 097 Nov-16 6 673 340 Dec-16 6 219 913 Jan-17 6 598 741 Feb-17 6 280 318 Mar-17 6 725 122 Apr-17 6 395 875 May-17 6 460 487 Jun-17 6 616 062 Jul-17 6 426 271 Total 77 882 076

 Calendar Month Sales Lowest Month Sales Aug-16 6 092 970 6 092 970 Sep-16 6 862 879 6 092 970 Oct-16 6 530 097 6 092 970 Nov-16 6 673 340 6 092 970 Dec-16 6 219 913 6 092 970 Jan-17 6 598 741 6 092 970 Feb-17 6 280 318 6 092 970 Mar-17 6 725 122 6 092 970 Apr-17 6 395 875 6 092 970 May-17 6 460 487 6 092 970 Jun-17 6 616 062 6 092 970 Jul-17 6 426 271 6 092 970 Total 77 882 076
• ###### Re: Values to repeat in a chart straight table

FirstSortedValue( Total Aggr(Sum(Sales), [Calendar Month]), [Calendar Month])

• ###### Re: Values to repeat in a chart straight table

Hi,

I would have thought of something like this:

\$(=Min(Aggr(Sum(Sales),[Calendar Month])))

Is the value in red the lowest monthly sales, or is it the monthly sales of the oldest month?

Cheers,

Luis

• ###### Re: Values to repeat in a chart straight table

Hi Luis

It is the sales of the oldest month.

Kind regards

Nayan

• ###### Re: Values to repeat in a chart straight table

Then it could be this assuming that your month is has a Dual value in the script

Sum(Total {<[Calendar Month]={\$(=Min([Calendar Month]))}>} Sales)

I hope this helps,

Luis

• ###### Re: Values to repeat in a chart straight table

Thank you Luis.  It worked.

Kind regards

Nayan

• ###### Re: Values to repeat in a chart straight table

Hi Treseco