Not Sure understand your question. You use dashboard to combine them and add filter action for interactivity.
When I bring 2 sheets on a dashboard together, they do not scroll down or up simultaneously. When i scroll down left sheet, right one remains static and vice versa.
Hence I thought of merging the 2 sheets together.
I want both the sheets to scroll down or up simultaneously.
Why not just put whatever pills you have on sheet 2 onto sheet 1? It looks like you're using the same datasource for both.
One sheet contains data about last 3 months in this case Oct, Nov, Dec and other sheet contains week wise breakup of the latest month in this case break up of December month. My requirement is such that I need all months data as well as break up of latest month.
Was unable to do it in a single sheet. Hence did it in 2 worksheets. I need to join these 2 sheets now. Is there a way out for this.