How to read multiple values from a filter pane

[siddharthsoam]

Hi

Please  tell me how can I fetch multiple values from a filter pane . I have a accounting period filter from which I want to calculate a certain measure of the previous selected period.

For example if I select counting period as 4,5 it should return me sum(revenue) for 4 and 3 month.

Thanks in advance

[woshua5550 · Accepted solution]

Try this

=Sum({<[counting period]={$(=Concat(Distinct [counting period]-1,','))}>}revenue)

[agigliotti]

maybe this:

=sum( {< [counting period] = {">=$((=min([counting period])-( GetSelectedCount([counting period])-1 ) ))<=$(=min([counting period]))"} >} revenue )

[siddharthsoam]

Hi Dave,

Its working well only its not giving me any data for 1 counting period

[siddharthsoam]

I am using the following expression

if(H1='Previous Completed Quarter', Sum({<Quarters={$(=Concat(Distinct Quarters-1,','))} ,[Accounting Period]={$(=Concat(Distinct [Accounting Period]-3,','))}>}[Service Rev]),

if(H1='Recent Completed Quarter',sum({$}[Service Rev]))

))

where h1 is the header  and quarters are fetched from accounting period as follows.

quarters accounting period

  1               1,2,3

  2               4,5,6

  3               7,8,9

Problem is data is showing correctly for quarter>1 , but for quarter 1 no data is being shown

[woshua5550]

because when you select quarter 1 it will calculate 'quarter 0' which is not exist

what data do you want to show for 1 counting period ?

[siddharthsoam]

Hi Dave this is the view I am trying to create , yes I agree that previous data for quarter 1 should not reflect, but it should show me quarter 1 data under recent completed quarter.

[woshua5550]

I don't think 'H1' makes sense,you may need to get rid of it ,just go with two expressions like this

expression for previous completed quarter :

Sum({<Quarters={$(=Concat(Distinct Quarters-1,','))}[Service Rev])

expression for recent completed quarter :

Sum([Service Rev])

[siddharthsoam]

Hi Dave,

My requirement consists of multiple headers thus I have to make inline headers. I cannot use differnet measures for previous and current.

[woshua5550]

ok , then we can combine the two expressions and try

IF(H1='Previous Completed Quarter',Sum({<Quarters={$(=Concat(Distinct Quarters-1,','))}[Service Rev]),Sum([Service Rev]))

you may need to attach your qvf file if it still doesn't work