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

[siddharthsoam]

Qvf in attachments.

[woshua5550]

sorry , I typed wrongly ,this would be ok

[siddharthsoam]

Quarter 1 data is still not showing up . Don't know how to proceed. Expected output should be like this.

[siddharthsoam]

Thanks dave looked into the wrong file..:)... But not able to change data by altering accounting period, when I change the expression to this

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

No data shows up under Q1 . Using your expression I am able to get Q1 under recent but when I change the accounting period(month) under a quarter ,it shows null value. I want that when I select quarter Q2 and accounting period 4,5 under recent ,it shows me quarter 1 , accounting period 1,2 under previous header.

[woshua5550]

oh ~ I got you see this

btw , if you don't select anything ,"pervious completed quarter" will show Q1+Q2+Q3 data

[siddharthsoam]

Thanks Lou Needed this desperately ...

[siddharthsoam]

Hi Lau,

I am also having some trouble putting in condition for displaying year-2016 Quarter 4 data in previous when user selects  fiscal year-2017 and quarter 1. Can you tell me where I have to put the if condition ?

Thanks in advance. Appreciate your help and patience on this

[woshua5550]

Well , I see

this will be quite different from what we did, I think we'd better figure it out relying on a better data set

so plz attach your data source file which named "FY16.xlsx" and "FY17.xlsx" in my view

[siddharthsoam]

Hi Lau,

Got it after trying certain possibilities , simple if condition outside our measure made it to work