Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
Access is denied to the Document it fails to load
Regards
Alan
sorry let me remove the section access and put it back...
attached is the application without section access..
Alan, Thanks for your help in advance
any help on this
Hi Vinay,
You can add
IF($(temp) > $(BB_ACT_Margin%),$(temp))
to Style Dimension in the Sort Tab >> Expression
Does that help?
Hi Alan, thanks for your reply let me try that and get back to you ....
ok
I helped me little bit ,,, but did not do the job... Sport dimension is messing up everything there....