Notifications
Clear all
Topic starter
Hello
I have a dashboard that has some graphs showing data monthly and others showing quarterly. They are all using the same "raw data" sheet. For the quarterly, I want to avoid showing Q2, for example, until all 3 months of Q2 are there. Each chart has their own "period" named range.
I tried to control with a field that indicated if month is July, then offset is x and use that value for the offset formula of data i.e.
=Offset(IP_Cases!$K$3,0,0,CountA(IP_Cases!$K:$K)-x,1)
but I couldn't get that to work. Any suggestions welcome, thanks.
Posted : 27/09/2017 2:10 pm
Hi Shelley
It would help if you could attach a sample file of what you have done. Otherwise it is hard to interpret your needs.
Sunny
Posted : 27/09/2017 8:56 pm
