Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I add measures, such as Quantity 1 and Quantity 2, to a filter pane? However, I want them to be displayed as 'Quantity 1' and 'Quantity 2' within the filter pane, and when I select one of these values, I want the data within the pivot table for Quantity 1 to be sorted from largest to smallest.
You can create the field in the script:
MeasureSelect:
NoConcatenate Load * Inline [
SelectedMeasure
Quantity 1
Quantity 2
];
This expression returns 1 if in this case 'Quantity 1' is selected and 0 if not:
Coalesce(SubStringCount(GetFieldSelections(SelectedMeasure, '|'), 'Quantity 1'), 0)
You need to add a field that has the names of your measures.
You can check whether a value is selected by using SubStringCount and GetFieldSelections.
Create an expression for the sorting of every measures in the table.
ok, can you give an example or something?
I don't understand what you exactly mean.
You can create the field in the script:
MeasureSelect:
NoConcatenate Load * Inline [
SelectedMeasure
Quantity 1
Quantity 2
];
This expression returns 1 if in this case 'Quantity 1' is selected and 0 if not:
Coalesce(SubStringCount(GetFieldSelections(SelectedMeasure, '|'), 'Quantity 1'), 0)