Sorting Problem in Pivot Table ..

[#1]

Hi Frnz,

I have pivot table. In this, it is showing Top 15 Accounts. I have done pivoting on YEAR.

I need to do sorting by 2015 values ? Is it possible to show Totals in last row by year wise ?

[#2]

Hi

   I Don't think so row wise sorting in qlikview

[krishna20]

Hi Tulasi,

Can you please attach sample file.It will be easy to sort out your problem .

[Anonymous]

I am not sure,but give it a try

goto sort tab and select your expression

define: =sum({<YEAR={'2015'}>}Value) descending

[#5]

Hi,

Please check attached Qvw. I need Sorting in 2015 values. And is it possible to show Totals in Year wise.?

[#6]

Hi,

I need descending order for 2015 values. Please find the attached QVW.

[Digvijay_Singh]

Doesn't look easy in Pivot table, below is relevant post on this -

Sorting in pivot tables

[krishna20]

Hi ,

Is this???

[Anonymous · Accepted solution]

Hi!
You should use the expression:

sum({<Year={"2015"}>}Sales)

Put it in your sorting tab under AccountName, make sure its descending, and that al other sorting under Year is off.

[#10]

Hi,

Yes exactly i need like this. When I use this expression, I am getting like below image. I need 2015 values in top of the table.