Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a problem with Set Analyses in a pivot table.
This is my set Analyses for AVGPrijs =avg({<stationId={"$(=vEigenStation)"} >}DagPrijs)
I would like to compare the value of the records with the value of my reference station (StationId = 1008)
Is there a solution to get the AVGPrijs of the reference-station in everry row?
Regards,
Kris
Yes, it should be:
=avg(TOTAL <YearField> {<stationId={"$(=vEigenStation)"} >}DagPrijs)
Hi Kris, can you try?:
=avg(TOTAL {<stationId={"$(=vEigenStation)"} >}DagPrijs)
Hi Ruben,
thanks for your answer.
But now he gives the average value of stationId 1008. Is it possible to split it up in the years?
For 2014 : 1.435 and for 2014 =1.396
Yes, it should be:
=avg(TOTAL <YearField> {<stationId={"$(=vEigenStation)"} >}DagPrijs)
=avg(TOTAL <$(='['&getcurrentfield(MyDrillDownGroupNameHere)&']')> {<stationId={"$(=vEigenStation)"} >}DagPrijs)
Thanks Ruben!
This is what I was looking for 🙂