Set Analyses in Pivot table

[kris_vliegen]

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

[rubenmarin]

Hi Kris, can you try?:

=avg(TOTAL {<stationId={"$(=vEigenStation)"}  >}DagPrijs)

[kris_vliegen]

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

[rubenmarin · Accepted solution]

Yes, it should be:

=avg(TOTAL <YearField> {<stationId={"$(=vEigenStation)"}  >}DagPrijs)

[Gysbert_Wassenaar]

=avg(TOTAL <$(='['&getcurrentfield(MyDrillDownGroupNameHere)&']')> {<stationId={"$(=vEigenStation)"}  >}DagPrijs)

[kris_vliegen]

Thanks Ruben!

This is what I was looking for 🙂