matrix table - ranking based on hidden variable

[chrisHH]

Dear All,

I have a table like this:

Importance	Description of Item	Category	Agegroup	Value
0.9	Test 1	A	18-25	0.85
0.85	Test 2	A	18-25	0.90
0.81	Test 3	A	18-25	0.65
0.79	Test 4	A	18-25	0.95
0.6	Test 5	A	18-25	0.99
0.85	Test 2	A	35-59	0.84
0.5	Test 3	A	35-59	0.99
0.4	Test 1	A	35-59	0.64
0.35	Test 5	A	35-59	0.54
0.33	Test 4	A	35-59	0.85

Based on that I have two slicers:

• Category
• Agegroup

Then I built a matrix table with “Description of Item” and “Value”.

My problem is: within the table, the “Description of Item”-field is ranked alpabetical-wise.

But I want to achieve a ranking based on the Importance value (top down), even if I don’t have that importance within in the table.

For example I want to achieve thise:

Slider Agegroup: 35-39, Slider Category: A

Item	Value
Test 2	0.84
Test 3	0.99
Test 1	0.64
Test 5	0.54
Test 4	0.85

But I get this instead:

Item	Value
Test 1	0.64
Test 2	0.84
Test 3	0.99
Test 4	0.85
Test 5	0.54

Any idea how to fix this???

Cheers,

chris

[v-piga-msft · Accepted solution]

Hi @chrisHH,

It seems that you could create the table with the three columns and then Sort by the Importance value. 

Then you could hide the importance value under Format.

 

Best Regards,

Cherry