Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have a chart which has to change the values based on the conditions or selections made on the filter.
Conditions apply
Hi,
I didn't delve into the example application, but based on your description the
getfieldselection() and the getselectedcount() functions can help you.
If you want to manipulate a measure based on selection, let see the next example.
=if(getselectedcount(ColumnA)>0,sum(ColumnB),sum(ColumnC))
explanation: when any value is selected in ColumnA then the measure shows sum of ColumnB else ColumnC.
If you want to watch a specific value then:
=if(getfieldselection(ColumnA)='value',sum(ColumnB),sum(ColumnC))
explanation: when the 'value' is selected in ColumnA then sum of ColumnB else ColumnC.
You can combine with match as well:
=if(match(getsfieldselection(ColumnA),'value1',value2')>-1,sum(ColumnB),sum(ColumnC).
G.
any help