Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
i am facing one issue in straight table i.e. i have a table with mutiple columns. iam giving sample table below:
LOAD * INLINE[
MonthYear,Values
202001,2
202002,5
202003,6
202004,3
202005,6
202006,7
202007,5
];
here my question is if i select value it should display that selected month. for eg: if i select value is 6 related to monthyear 202005, it should display monthyear 202005 data in table not 202003 data like that i want to display yearmonth based on Value selection. can any one please help me on this.
May be this?
=If(GetSelectedCount(Values)>1, Aggr(Only({<MonthYear={"$(=Date(Max(MonthYear),'YYYYMM'))"}>} Values), Values))
If you select 6 then you have to show both 202003 and 202005?
Perhaps this? But, I wonder why it is needed to select on values which is data point?
If(GetSelectedCount(Values)>1, Sum({<MonthYear={"$(=Date(Max(MonthYear),'YYYYMM'))"}>} Values), Sum(Values))
HI Dmac,
I want to show only one selected value Monthyear.
HI Anil,
Thanks for your Reply. is it possible to write this condition on dimension level? because this value is linked with other sheet table. when i click on any value from table1 it will navigate to table2 and displays selected value Monthyear data.
May be this?
=If(GetSelectedCount(Values)>1, Aggr(Only({<MonthYear={"$(=Date(Max(MonthYear),'YYYYMM'))"}>} Values), Values))