Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a data where Period calculations such as MTD, QTD, YTD are mentioned in separate columns in back end data. I want to add a filter in front end as MTD, QTD, YTD and then want all charts in sheet to be populated as per flter selection and take values from correct columns. For example - If I select QTD in filter, all charts should refer to QTD column in the back end and return the correct values for selected period.
hi
assuming you create a period field with the values MTD,QTD,YTD
than you can set this field to one selected value
than in your measures use this expression for example
=$(='sum(' & period & ')')
this assumes that in your data you have columns with the names MTD,YTD,QTD