brand purchase value sales values
———————————————————————-
honda 5000 4000
volvo 3000 6000
it is opened rows
how can i write pivot in mssql for this form: (opened columns)
honda volvo toyota etc…. opened brand===>>
purchase value 4000 5000 6000
sales values 6000 7000 8000
brand purchase value sales values
———————————————————————-
honda 5000 4000
volvo 3000 6000
it is opened rows
how can i write pivot in mssql for this form: (opened columns)
honda volvo toyota etc…. opened brand===>>
purchase value 4000 5000 6000
sales values 6000 7000 8000
Anyone from team kindly answer the query above !