Including Record # in one Document

[#1]

Good morning,

I need to include in one document a record number following some criterias. I attached a Excel sheet explaining the topic. If somebody can help me I will appreciate.

Thaanks in advance

[alexandros17]

You can do this in two ways:

1) in the chart by using RowNo() in one expression that numbers rows according to theirs positions.

2) in the script, setting the order and addina a new column with rowno()

hope it helps

[#3]

Thanks fot your quick response. As you can see if I include the rowno(). Here are the resutls:

WEEK	SKN	Price	CATEGORY	rowno()
		5.415.129	-	-
9	442437	465	1	1
9	31011	1.738	1	2
9	335207	2.275	1	3
9	442445	178	1	4
9	145734	3.685	1	5
9	442526	49	1	6
9	248010	284	1	7
9	118699	1.404	1	8
9	442399	270	1	9
9	565350	21	1	10
9	134287	1.014	1	11
9	99570	63	1	12
9	60240	1.781	1	13
9	227552	1.159	1	14
9	315672	1.916	1	15
9	557137	982	1	16
9	146854	906	1	17
9	557013	1.079	1	18
9	312940	1.062	1	19
9	676209	1.107	1	20
9	29726	288	1	21
9	331902	815	1	22
9	102261	978	1	23

The result is not sorted by 'Price'. Thanks

[alexandros17]

Yes, it's true,

in the sort tab (properties of the chart) you have to sort by price in descendent order.

[#5]

I already tested, but when you have a rowno() column and uses the sort by price is not working

[alexandros17]

You have to sort SKIN (promote it) setting the expression (descending) as sum(price) (if this is the expression you use for price ....

Hope it helps

[#7]

Hello,

In the sort Tab, sort with 2 criteria :

first the category then the expression you use to calculate the Price ( Sum(Price) for example.

[#8]

Sorry,

But I don't understand whar do you mind.

[alexandros17]

I suppose that WEEK and SKN (Not SKIN) are dimensions and Price, Category and RowNo are expressions.

If this is true you have to define the sort criteria.

Go to the sort tab:

1) select SKN and with button promote it to the top, setting the sort criteria with the expression (click the checkbox) and use as expression the same expression you use for price.

2) select other fields in sort tab and uncheck sort criteria

I Hope I have been clear, if not, let me know

[#10]

It's not working. I have as Dimension SKN, CATEGORY and I sorted by CATEGORY and after SUM(PRICE)