Chart with Total and Subtotals for Two or More Dimensions?

[markecirillo]

Hello,  I have been trying to find a chart (stacked bar chart, pie-chart, or really anything) that would show the average values for two dimensions (let's say Avg(ETIME) = 10, and Avg(ITIME) = 5) along with the total of both in one graphic.  Or a marker in the Combo Chart would work if it could display the value.  The closest I've been able to get is a regular bar chart using a new field for the total (E+ITIME) that shows all three individually but this doesn't meet the requirements.  Thanks.

[rogerpegler]

How about rearranging your data into a table with a dimension field that has ETIME and ITIME as possible values and their data in a data field? 

Your could then have a Combo Chart with the dimension field as dimension and two measures being sum(data) and avg(data).

[markecirillo]

Thanks for the reply but I'm not sure I understand.  Let's say I have this simplified table.

Item / ETIME/ ITIME

ITEM1 / 8 / 3

ITEM2 / 10 / 5

ITEM3 / 12 / 7

What would I need to do?  Thanks again!

[rogerpegler]

Using your sample data, table like the following

Item / TimeType / Value

ITEM1 / ETIME / 8

ITEM1 / ITIME / 3

ITEM2 / ETIME / 10

ITEM2 / ITIME / 5

ITEM3 / ETIME / 12

ITEM3 / ITIME / 7

Then TimeType as a dimension (Item as well?) and sum(Value) and Avg(Value) as Measures.