Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I got one issue in set analysis in QS, I have a filter pane for year selections so what i am trying to do is when i select any year from filter pane(Year) lets say I selected 2020 then my sum expression should show the sum of 2020 amount.
my sum expression is ->
Sum({<Year1= {$(=GetFieldSelections([=Year1]))}>}[Amount Millions])
where Year and Year1 are columns in dataset and Year column having Data like FY19,FY20(fiscal year) etc... and Year1 is having data like 2019,2020,2021.
Year1 is used for filter pane.
Bt the issue is when i am selecting any year , it is not showing the sum of amount instead it is showing 0.00
pls help .
Thanks
Try this
Sum({<Year1={'$(=GetFieldSelections(Year1))'}>}[Amount Millions])
Is your Year1 field is in the same table as [Amount Millions] so you wouldn't need to mention anything in your set expression, upon selection it should show the desired value with
sum([Amount Millions])
If not in the same table, maybe you can show us the data model(or explain)
If there are two fields of Year with similar values but different table not connected to each other you could use
sum(Year=P(Year1)[Amount Millions])
i.e. from your year field you could extract 2019, 2020 from FY19 or FY20.