Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two list boxes one with column names and the other with Asc/ Desc options. I could sort the data in straight table using the column in the first list box using sort expression like
=if('$(vSort_FieldName)'='WAL',Sum(WAL))
But how do I link with second list box Asc and Desc. When the user selects column2 and Desc, data in chart should sort accordingly.
Please help.
Thanks,
JP
Use two list boxes, one sorted asc and one sorted desc. Then use the Conditional display option on the Layout tab of the properties windows of the listboxes and enter an expression that returns 1 or 0 to show or hide the listbox based on the selection of the Asc-Desc listbox.
For the Asc sorted listbox: =If( AscDescField = 'Asc',1,0)
For the Desc sorted listbox: =If( AscDescField = 'Desc',1,0)
See if the below link will help you...
Pivot table - dynamic sorting using variables - identifying # dimensions in chart