I would really like to just have an option to select one filter, like Travel, in a Department drop down menu. While retaining that filter, add a new one, like USD, in a Currency drop down menu. But every time I select a new filter, the old filter no longer remains.
On Feb 23, 9:51 am, S <[email protected]> wrote: > Hello, > > I'm currently trying to modify HTML under Visualization - More query > options. > > I have a table with columns: > > Employee Name Expenses Currency Department > > Ex: John 32.00 USD > Travel > Karen 1,000 > USD Entertainment > George 21.00 USD > Travel > Mary 9,000 > JPY Travel > > I would like to filter data so that different departments are > separated and broken up based on currency. > For example: > > Employee Name Expenses Currency Department > > John 32.00 USD Travel > George 21.00 USD Travel > > So this example filters data to display only Travel departments and > filtered again to display only USD > > I would also like to take the above table and perform a pivot / label > to sum the expenses in a new table: > > Department Currency Total > > Travel USD 53.00 > > Any help is greatly appreciated! -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
