I was reading the Excel blog on a very cool feature that I’m personally looking forward to. With the Excel Interactive View, I can add a button to my web site that brings up an interactive spreadsheet with data and allows visitors to interact with that data. Tableau has done some of this with their public version, but you just cannot beat Excel for people knowing how to use it.
Enjoy, Patrick
I would like to ask, if it is possibility to add some more additional attributes in Excel Interactive View button command list. I would like to have some kind of a table like this one
Indicator Year
2009 2010 2011 2012
Population
Male
Female
Mortality
and make filter just for “Year”, I mean, that it would be a possibility to choose year: just 2010 or 2012 or all of its. Now Interactive View button make all columns like filters (Year1, Year2, …) and let me pick particular value of year. I don’t need to choose value in filtered year, I just need to select specific year. Is it possibility to do with this Interactive View Button? At first I found this Button I was surprised and happy, but when trying to do I really need, something went wrong… Maybe it is some other possibility to do like this? I would appreciate for You help!