Below is the sample data set, I want to create a straight table as shown in output.
Requirement: the country name which made the max sale for every year.
Thanks in advance
Why do you want to move it to a pivot table? Your initial questions seems very well suited for a straight table presentation.
Please attach an example of what your pivot table looks like, so we can understand how you have done the pivot table.
The sample that I have posted above has just 2 dimensions, but in actual scenario there are three, I was hoping that i can replicate the result for three dimensions once i get an idea here
If(Sum(sales)=Max( TOTAL<dim1,dim2> Aggr(Sum(sales),dim1,dim2,dim3)),Sum(sales))
I was trying to get one dimension horizontal and another vertical so wanted to switch over to Pivot.
Please find attached the sampe excel with the expected output.
Thanks in advance.
Thanks for the reply, Attached the sample data and output required. Sorry for the trouble i thought i will be able to replicate the sample to my scenario