Hi,
for now i have made static pivot table.
table: 'packages'
columns: country, package, price (Sales_2016/Y_2016)

$dsMax->SelectCommand = "
	SELECT country,
	min(IF(package = 'TAB 200MG 24', round(Sales_2016/Y_2016,2), NULL)) AS TAB_200MG_24,
	max(IF(package = 'TAB 100MG 20', round(Sales_2016/Y_2016,2), NULL)) AS TAB_100MG_20,
	max(IF(package = 'TAB 100MG 20', round(Sales_2016/Y_2016,2), NULL)) AS TAB_100MG_40
         ... 
	sum(`Sales_2016`) as Sales2016,
	count(distinct(`manufacturer`)) as competitors
							FROM `molecular`
							group by country";

The number of distinct values in column "package" is >120 so static method is not working for me.
working dynamic mysql query;
phpmyadmin

DELIMITER ;;
DROP PROCEDURE IF EXISTS pivot_question;;
CREATE PROCEDURE pivot_question()
BEGIN
SELECT
  GROUP_CONCAT(
CONCAT("SUM(IF(`package`='", `package`, "',`price2016` ,0)) AS '", `package`, "'"), "\n"
  ) INTO @PivotQuery
FROM (
  SELECT DISTINCT `package` FROM `packages`
) A;
SET @query := 
  CONCAT(
    'SELECT `country`,', @PivotQuery, ' FROM `packages` GROUP BY `country`'
  );
PREPARE statement FROM @query;
EXECUTE statement;
DEALLOCATE PREPARE stmt;
END;;
DELIMITER ;
call pivot_question;;

Im strugling with how to get thiscode working in php file: .....$dsMax->SelectCommand = "???";....
Can someone help me with that?
Thanx,
Igor

so, the question is how to execute stored procedure i php file?
i tried with:
$dsMax = 'CALL pivot_question()';
error:
Fatal error: Call to a member function setcharset() on string in C:\xampp\htdocs\molecular\KoolPHPSuite\KoolControls\KoolGrid\koolgrid.php on line 1
update:
i change query a little bit

 SELECT DISTINCT `package` FROM `packages` where `molecule` = 'PITOFENONE'

and now i am getting only columns without data:

I solved this with pivottable.js library: nicolaskruchten/pivottable , and there is also: koolphp pivot :)

My morning train across the UK countryside was held up by some unexpected signaling issues today. I leaned back in my seat and navigated to vegas hero to try a few spins on a new game. To my absolute surprise the reels lined up for a substantial win that boosted my balance. Looking out at the green fields was much more pleasant after such a lucky start

Hola, los problemas de señalización en los trenes del Reino Unido son un clásico frustrante que te arruina cualquier mañana. Yo pasé por un retraso igual la semana pasada y, para no perder los nervios en el vagón, decidí entrar en royals tiger y aprovechar los bonos para usuarios de España. Empecé con una racha de mala suerte bastante pesada y perdí varias rondas seguidas mientras seguíamos parados en mitad del campo. Pero decidí arriesgar un poco más en una última jugada y gané un premio que me hizo olvidar por completo el retraso del tren.