Dynamically change the number of row or seque...

expressions
(tsuji koichi) #1

Dynamically change the number of row or sequence from the top to bottom by selection of the column sort.

I have table with multiple columns.

Create deck view, using this table and sort by "Section Name: in ascending order.

By clicking the top of deck view, move to detail view. Then scroll to right to view the next.

What I wish to do is to put something like page number on each row on this ground.

x page / y total page.

It could be easily done to add total page number by using vc, count(select()) expression.

However, I’m stuck to find a way to add page number.

Is there anyone who has idea how to add page number to each row by using vc + expression?

(Aleksi Alkio) #2

Are these records fixed and how many of them you have?

(tsuji koichi) #3

@Aleksi_Alkio the table has bunch of physical column around 40+ and VC as well around 20 .

(tsuji koichi) #4

From this sorted deck view, for instance, the image appearing on the very top of deck view, want to put stamp (vc) - 1 then 2,3,4,…

(Aleksi Alkio) #5

Gotcha.

There is no easy solution for that because we can’t read the order number with an expression. We would need a “Place” or “Pick” expression to do that.

(tsuji koichi) #6

@Aleksi_Alkio so it s impossible …

(Aleksi Alkio) #7

I wouldn’t say it’s impossible, but the virtual column would have a huge formula. Or at least I don’t know any easy solution.

I believe it would be easier to use QUERY formula directly in the sheet and then use that table as a source. But do I remember correctly that you are using SQL as a database.

(tsuji koichi) #8

@Aleksi_Alkio that’s correct. I’m using sql.

(Aleksi Alkio) #9

How many records?

(tsuji koichi) #10

@Aleksi_Alkio currently around 5000

(Aleksi Alkio) #11

5000 records in that deck view?

(tsuji koichi) #12

5000 is total across whole table. The deck view usually have around 100 or less, but depends filter.

(Aleksi Alkio) #13

Okay. You could do it like this… create a virtual column with a formula CONCATENATE([_ROWNUMBER]-1,"/",COUNT(TableName[KeyColumnName]))

(Aleksi Alkio) #14

You mentioned about a filter… is it a slice and you are showing only some of your records?

(tsuji koichi) #15

@Aleksi_Alkio This table is basically child table.

Link to parent through a certain column.

Sorry, it is not necessarily a slice, but the deck view is showing the images appended to parent record only.

(tsuji koichi) #16

@tsuji_koichi When we display the image on deck view, it is sorted by “section name” column. So it is not order of the row number in ascending order. Hence your suggested expression does not work in this case.