9 Replies Latest reply: Apr 22, 2015 1:39 AM by anbu cheliyan

# Pivot table how to sort hi to lo for 2015 year column ?

Hi All

How to sort hi to lo for this table 1 For 2015 column  ?

Paul

• ###### Re: Pivot table how to sort hi to lo for 2015 year column ?

Enclosed my QV Doc

• ###### Re: Pivot table how to sort hi to lo for 2015 year column ?

go to properties of the chart and on the sort tab.

• ###### Re: Pivot table how to sort hi to lo for 2015 year column ?

Hi Sir

it does not work.

Paul

• ###### Re: Pivot table how to sort hi to lo for 2015 year column ?

see the attached app.

• ###### Re: Pivot table how to sort hi to lo for 2015 year column ?

Hi Sir

what i mean is i like the amount sort from hi to lo , look like below :-

 P&L Heading year 2,015.00 2,014.00 PAYROLL 19.23 24.59 TOTAL ADMIN EXPENSES 18.07 32.56 GENERAL EXPENSES - ADMIN 13.03 24.17 COMMUNICATION - S & D 3.55 3.15 PROFESSIONAL FEE - ADMIN 1.49 4.23 STAFF WELFARE - ADMIN 0.81 1.57 COMMUNICATION - ADMIN 0.40 0.47 SALES & PROMOTION - S & D 0.29 2.89 GENERAL EXPENSES - S & D 0.23 1.18 STAFF WELFARE - S & D 0.20 0.64
• ###### Re: Pivot table how to sort hi to lo for 2015 year column ?

Hi

class function and dual:

this is used to without field select add  calculation  dimension and when null value to select 'suppress when value is

null .

example : dual is consider the numeric and text.

dual(class([ordertotal],1000),class([ordertotal],1000),

sort tab select numeric values .

try once

Thanks,

srinu

• ###### Re: Pivot table how to sort hi to lo for 2015 year column ?

Hi,

Try like this

Chart Properties -> Sort -> Select Dimension -> Select Expression and give below expression and select Descending

=sum({\$<           year={\$(=Max(Year))},          month=,MonthSeqNum = {"\$(= '>=' & only(MonthSeqNum-7) & '<=' & only(MonthSeqNum))"} >}  Amount*-1/\$(ColumnDim98)/1000)

Hope this helps you.

Regards,

Jagan.

• ###### Re: Pivot table how to sort hi to lo for 2015 year column ?

Check this app

Use like the below expr on P&L Heading in Sort tab

Sum({<Year={2015}>}Sales)

• ###### Re: Pivot table how to sort hi to lo for 2015 year column ?

I don't think its possible to sort it by Y-value on the pivot table.