Question

Aggregate data based on dissimilar rows value

  • 21 September 2019
  • 0 replies
  • 16 views

Is there any way to aggregates sales and other columns based on dissimilar rows values. I have one column that has different rows values


for example:


Product name state Sales1 Sales 2


AA 1 CA 12 11


AA 2 AL 11 15


AA 3 NY 13 25


I want to group the three Product name and give it a name as AA and see the pivoted sales. and keep the state and other column as it is.


0 replies

Be the first to reply!

Reply