Sort and Slider in a straight table...

[#1]

Here is an requirement. I don't have DB access. I am given only the QVDs which I can't modify.

Thank you.

[#2]

Hi,

look the attachment example for Requirement(1).

Regards

Mario

[#3 · Accepted solution]

Hi,

look the attachment example for Requirement(2).

Regards

Mario

[#4]

I tried this. I have 25 columns in the straight table of which 15 are dimensions and 10 are expression (e1, e2,..e10). AmtDue is e8-e7.

The Fabs() works good in another pivot.

Do I need to copy the fabs() to all the dimensions?

[#5]

No,

you must set priority of columns of sort tab as First on one dimension with Fabs in expression.

I hope this helps

[Gysbert_Wassenaar]

You can use an expression like fabs(sum(rangesum(ProposedAmt,-AmtCollected))) for Sort by Expression (on the Sort tab).

The same expression works as well to have the slider work correctly. See attached example.

[#7]

Thank you. This resolves my issues.