Help in row selection

[pradosh_thakur]

hi

Please find the attached qvw.

It has a pivot table. I need to select 1,3,5,10,15,20 rows of corresponding item and show the in below format. A pivot or straight table will do.

regards

Pradosh

[prma7799]

Have you tried "If(Match(ID, 1, 3, 10, 15, 20),ID,Null())" for calculated dimension in Pivot table?

[Sergey_Shuklin]

Hello!

Please, look at the picture below and the attachement. Is this the goal?

[pradosh_thakur]

Hi

I want the row no not the ID.  and you can see there is no id in the output.

regards

Pradosh

[pradosh_thakur]

Hi Sergey

looks promising buddy. Let me Apply that in my app and will get back.

Thank you.

regards

Pradosh

[pradosh_thakur]

Hi Sergey

The sorting seems create some problem.  i need the sum to be in descending order first then sort the row.

regards

Pradosh

[Sergey_Shuklin · Accepted solution]

Hello!

If you are using QV12 you can solve this with sort condition of the second parameter of Aggr() function:

There are some curved red lines - don't pay attention on them.