How to show data by selectig different calender dimension
Hi All,
I have a sheet which has different chart KPIs , bar and pie etc. and on top we have three selection , show data by Quarter , Month or day. As of now we are using different if condition in every chart to show the selected set of data.
if('$(vselection)'='Month', Sum($ (suits),
if('$(vselection)'='Quarter',Sum($ (suits),
if('$(vselection)'='FY', Sum($ (suits), )))
is there any other way we can achieve this because I think that can improve performance.
