Straight/Pivota Table

[nisha_rai]

Hi ,

I want to create the bleow table with the same formate which is mention below, Can any one please help me how we can create the below table

Regards,

Nisha

[adamdavi3s]

Ok now we have a starting point

Please see the attached example and lets work out what needs to change to meet your requirement

[nisha_rai]

Hi ,

In place of total I want the L1 Name, I don't want the  L1 Name as a seperate column

[vinieme12]

See Attached sample app

[nisha_rai]

Thanks Vineeth,

If our Account Name increase then ,is that solution is feasible. And can we make that dimesion dynamic

[vinieme12]

You will have to manage the inline table

But i'll try to think of any other ways

[vinieme12]

See this post

Partial Sums in straight table | Custom Labels in Pivot SubTotals

[nisha_rai]

Thanks Vineeth, But that is not exactly what I want, I don't want Extra Column, For example

As per your attachment you have two column one is Display Country List and other is Name, i want the display country name comes below the Name row

Like that

Name	2016	2017
Ted	40000	48000
Sienfield	60000	72000
US	100000	120000
Jack Sparrow	50000	60000
Sherlock Homes	35000	42000
UK	85000	102000
Takeshi	30000	36000
Naruto	80000	96000
Japan	110000	132000
All Region Cost	295000	354000