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.
TIA!
