sum of columns instead of sum of rows

[#1]

Sorry, I can't explain better. I have a table like this:
-------------------- Sales ---------------------

Sales DE | 100 | 110 |

Sales UK | 80 | 40 |

Sales IT | 200 | 220 |

Total | 380 | 270 |

I'd like to have a table like this

-------------------- Sales ---------------------

Sales DE 210 | 100 | 110 |

Sales UK 120 | 80 | 40 |

Sales IT 420 | 200 | 220 |

anyone can help me? Thanks

[johnw]

landini.m wrote:Ok, thank you, but as you can see I cannot swap the Horizontal dimension to Vertical... I don't know why

I'm not sure what you mean by "as you can see", since my posted example does exactly that with your own chart. But I can understand not WANTING to do it that way, which is why I posted a second but more complicated solution.

[#3]

Could it be as easy as turing on Partial Sums on the hour 'ORA' field?

Properties -> Presentation

Select 'ORA' in the list box and check 'Show Partial Sums'