Line Graph - showing value for one dimension(one line per item) and total

[Anonymous]

Hi

I would like to know if it is possible to do a line graph containing a line per item of the dimension used and one line for the total (ie for all items).  In my case, I have sum of sales for each month per country.  I need a line for each showing the sales per month and one line for the total of sales for all countries for each month.  I would like to have month and country as dimension for the chart.  Please find attached a sample excel sheet with the data

Thanks

Hasnaa

[bbi_mba_76 · Accepted solution]

Hi,

maybe you could use the dimensio limit tab, with the show total flag.

[Anonymous]

Hi.  I tried it. It works

Thanks

Hasnaa