Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!!
Could you elaborate/post your data?
Do you need the money format or green tab???
Hi Robert,
Thanks for helping, find attached a small sample of the data source please.
I need the money format.
Thank you.
Like this?
I can not reproduce your layout exactly , I can not see any Country column but..
In Fixed to or Integer
#,##0 €
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.
Attached the same data as on your example.
I do not see Country anywhere.
Attached qvw file not the csv data
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.
Post your qvw...