sort pivot

[Anonymous]

hi

i made calculte dimansion with 2 feilds "q &'-'& year"

i want to sort pivot table by this demansion , exm :

q1-2014, q2-2014,q3-2014,q4-2014,q1-2015,q2-2015....

how to do it ?

thanks'

yarin.

[john9inno]

Go to propreties and select Sort tab.

you will have options in dimensions window to choose.

John

[john9inno]

use the source data field to sort the data.

however, adding that quater field at load could perform quicker when data size is not small.

[Anonymous]

Hi,

Please go through this thread:

Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)

Hope it will helpful!!

[ecolomer · Accepted solution]

You can use "expression" on label order and put year&quarter

[sunny_talwar]

Try this as your calculated Dimensions:

Dual(Quarter & '-' & Year, Num#(Year & Right(Quarter, 1), '##'))

and then sort your calculated dimension by ascending or descending based on your requirement.

Edit: Assuming Quarter contain values like this -> Q1, Q2, Q3, Q4