13 Replies Latest reply: Aug 5, 2015 5:32 AM by tulasiram b

# Sorting Problem in Pivot Table ..

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 ?

• ###### Re: Sorting Problem in Pivot Table ..

Hi

I Don't think so row wise sorting in qlikview

• ###### Re: Sorting Problem in Pivot Table ..

Hi Tulasi,

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

• ###### Re: Sorting Problem in Pivot Table ..

Hi,

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

• ###### Re: Sorting Problem in Pivot Table ..

I am not sure,but give it a try

goto sort tab and select your expression

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

• ###### Re: Sorting Problem in Pivot Table ..

Hi,

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

• ###### Re: Sorting Problem in Pivot Table ..

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

Sorting in pivot tables

• ###### Re: Sorting Problem in Pivot Table ..

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.

• ###### Re: Sorting Problem in Pivot Table ..

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.

• ###### Re: Sorting Problem in Pivot Table ..

Sorry..It is working Joey Stekkinger solution.

• ###### Re: Sorting Problem in Pivot Table ..

Oh good

• ###### Re: Sorting Problem in Pivot Table ..

Well, I dont know why it doesnt work for you.

I would like to send you the file, but I do not see the option to add an attachment.

• ###### Re: Sorting Problem in Pivot Table ..

Hi,

It is working no problem. Thanks for your solution..

And is it possible to show Totals in last row for every Year?