Column reference calculation in pivot tables as Excel, help!
Can someone help mewiththe followingproblem. I have apivot tablewhere theformulaneeds to be adjusted. The formulareferencedoncalculated columns. Howdo I get theformulacorrectlyadjustedso thatthe resultcorresponds totheattachedExcel(column Setandthe Dayend - correctformula).
Furthermore,the calculation forthe column Dayendshould be stored when I select the month 2 in the Listbox.
For example when I select the secondmonththen the Dayend is to be takenfrom the firstmonth -> last day from first month
The problem is you can't do the equivilent of "Ma_Networkdays = Datum_GLSTRT" in set analysis to reduce the data set. I don't understand your data model but you really should avoid having to do such expressions in the script.