Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
In the attached example I have a Pivot table with two cyclic group dimension. One for Calendar fields and another for another other relevant dimensions.
What I would like to do is add second expression that will calculate the % increase from the previous period , but still allow the user to change the calendar dimension from Month to Quarter to year to week etc. is there a way I can generically refer to to the previous period in a cyclic group dimension?
Many thanks
Lawrence
hei
attach is an example
it uses above functio
on quick check it seems to work
hope it helps you
hei
attach is an example
it uses above functio
on quick check it seems to work
hope it helps you
Thanks Liron,
I never new those functions existed, you certainly enlighted me to a whole new area of QV. I was trying to use GetCurrentField() within set Analysis, but your method is far simplier.
Many thanks again,
Lawrence