help with sorting in Pivot table

[Anonymous]

Hi i have  pivot table in which i have Item Type Desc, sport & Style and Name...with expressions shown below in the qvw document. All i want is sort on Style Dimension with the following expression if total Bgt margin % is less than 2014 ACT margin % then arrange those Styles in ascending order and if total Bgt margin % is greater than 2014 ACT margin % then arrange those Styles in ascending order. Please see the qvw document and as well as attached is the screen shot how it should look like....

[rustyfishbones]

Access is denied to the Document it fails to load

Regards

Alan

[Anonymous]

sorry let me remove the section access and put it back...

[Anonymous]

attached is the application without section access..

[Anonymous]

Alan, Thanks for your help in advance

[Anonymous]

any help on this

[rustyfishbones]

Hi Vinay,

You can add

IF($(temp) > $(BB_ACT_Margin%),$(temp))

to Style Dimension in the Sort Tab >> Expression

Does that help?

[Anonymous]

Hi Alan, thanks for your reply let me try that and get back to you ....

[rustyfishbones]

ok

[Anonymous]

I helped me little bit ,,, but did not do the job... Sport dimension is messing up everything there....