Pivot Table Sort Order Help

[haymarketpaul]

QV 11 SR4

See attached qvw

With the Industry Type column collapsed it nicely orders in descending User Count - I would like to order the User Count Expression column by descending Industry Type User Count when someone expands a job title.

[MK_QSL]

For job title use below in sort tab as an expression

=IF(Dimensionality() <> 2, Count(DISTINCT UserID))

[haymarketpaul]

Sorry Manish - i'm not sure that helps...

When i expand a job title i then want the industry type user counts in descending count order

[settu_periasamy · Accepted solution]

Hi,

Try this.

Enable the Y-value as Descending in Sort by option.

[haymarketpaul]

Perfect - Thank You

Will have to read up on Y Value