P&L pivot with function firstSortedValue

[Fab62400]

Hello,

I use the P&L Pivot with the function  FirstSortedValue ( to make a TOP of max value by month for production workshop)

I have a table with the PERIOD, WORKSHOP , VALUE , ACTIVITIE ( is a type of VALUE )

So in my case , I use this function to show the  first workshop

=(FirstSortedValue ({<ACTIVITIE = {'Ton month'},Pays = {'France'},PERIOD = {">=$(=MonthStart(Max(PERIOD), -11))<=$(=MonthEnd(Max(PERIOD)))"}>} WORKSHOP, -VALUE,1))

And  this to show the value :

=(FirstSortedValue ({<ACTIVITIE = {'Ton month'},Pays = {'France'},PERIOD = {">=$(=MonthStart(Max(PERIOD), -11))<=$(=MonthEnd(Max(PERIOD)))"}>} VALUE, -VALUE,1))

Only the value is display but not the name of workshop.

I use this function with a Qlik sense pivot graphic and it’s ok. Could you help me ?

Thank you