
Re: Column reference calculation in pivot tables as Excel, help!
Mark Sheraton Jun 3, 2013 11:01 AM (in response to Zeljko Mijailovic)See the attached file. I've added two new expresisons. The labels are in bold.
Set (correct formula)
Set (correct formula)  Is
Dayend (correct formula)
if(isnull([Set (correct formula)]),0,[Set (correct formula)])  Is

planning2.qvw 249.8 K

Re: Column reference calculation in pivot tables as Excel, help!
Zeljko Mijailovic Jun 4, 2013 3:24 AM (in response to Mark Sheraton)Hi Mark!
Thank you for your help that ist what I need, but I miss values on the month break!. How I can get this values?
Is it possible to hide the zero values of the rows when I use the inter record function (above etc...)
See attached screenshot.
Thank you!

planning.qvw 6.4 MB

Re: Column reference calculation in pivot tables as Excel, help!
Mark Sheraton Jun 4, 2013 9:02 AM (in response to Zeljko Mijailovic)See the attached file, not exactly straghtforards and probaly would have been better to do this in the script...
Mark

planning 3.qvw 6.4 MB

Re: Column reference calculation in pivot tables as Excel, help!
Zeljko Mijailovic Jun 4, 2013 9:40 AM (in response to Mark Sheraton)Hi Mark!
This is a great solution, but when I select the 2nd month then the set and dayend column loses the previously calculated values.This means the dayend is based on a different value then before.
See attached file.
How can I aggregate these values so that they do not get lost if you select something!Thanks

Re: Column reference calculation in pivot tables as Excel, help!
Mark Sheraton Jun 4, 2013 10:46 AM (in response to Zeljko Mijailovic)To do this you'll need to use set analysis and remove the selections you don't want (probably all of your dimensions)
sum({$<Ma_Networkdays=,GL$SYS_Gruppe=,Ma_Jahr_Monat=,Ma_Networkdays = Datum_GLSTRT>} GLPQOR/1000)
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.



