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.
