Table Chart with a custom format

[#1]

Hello,

Does anyone know how can I create a table chart with the following format:

Level		Cost	Cost Last Year	Cost YTD	Δ Cost YTD Last year
Store	Virtuals	345 €	42,5%	276 €	46,2%
Group	1	298 €	29,6%	268 €	21,6%
Region	Madrid	120 €	9,0%	114 €	8,9%
Country	Spain	125 €	15,0%	121 €	5,1%

Ive tried to use a pivot table and straigth table but i couldnt do it.

Thanks!!!!

[robert_mika]

Could you elaborate/post your data?

Do you need the money format or green tab???

[#3]

Hi Robert,

Thanks for helping, find attached a small sample of the data source please.

I need the money format.

Thank you.

[robert_mika]

Like this?

I can not reproduce your layout exactly , I can not see any Country column but..

In Fixed to or Integer

#,##0 €

[#5]

Hi Robert,

My biggest problem was not the formatting of the money, reproduce the layout exactly like I inserted in the question is my difficulty.

[robert_mika]

Attached the same data as on your example.

I do not see Country anywhere.

Attached qvw file not the csv data

[#7]

When I posted the the question, I I have changed the field to countries in order to be easy for you to understand, it was just an example, but the aim still the same.

[robert_mika]

Post your qvw...