table with two expression in a cell

[andrea1]

hi all.

is it possibile create a table like this:

My dimension is the Year, % are on total.

thanks in advance

Andrea

[sugathirajkumar]

Y cant you load it from text or excel

[andrea1]

Hi.

Numbers must be changed according on the selection

[jensmunnichs]

Hi,

I think you're best off using a pivot table to achieve this.

This is the closest I could get to your image (see attachment). I added 'Sales level 2'  to make up the rest of the total amount of sales per year. If I've misunderstood what your source data looks like, please post some sample data to work with.

[andrea1]

Thanks, but is not good for me.

Andrea

[sunny_talwar]

What is not good about this? Do you want to provide some more info?

[sugathirajkumar]

Creat it from Excel

[jensmunnichs · Accepted solution]

I managed to get even closer to the table in your image, though imo this one is a bit messier.

If this still isn't what you need I'm not sure I can help, especially if you don't give me any feedback on what's not good about it...

[andrea1]

Great! thank you very much