Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I know this should be done with alternate state or set analysis but I just cannot get it right.
I have a sheet with 2 chart - a table chart showing full data and a line chart of avg work time by month.
I have a few filters on the sheet - Customer, product, product_line, month
I want the table chart to filter according to all selections but in the line chart I want to keep showing all the months even if user selected a certain month.
how do I go about this?
i wanted to post your answer as solution and mistakenly clicked on mine
do you want to post it again?
I wanted to click on your response as accepted solution but mistakely clicked on mine
Is it possible to change?