Hi Nimrod,
perhaps could you answer one more of my question.
I have crosstab (list) and cascading prompt (year, month).
As the standard setting it give current year and alway a full month back (e.g today 27.2.2014) it give january.2014 back.
And on the crosstab have current year and last year (01.2014-01.2013 or 02.2013-01.2012 and so on) also the last year is dependent the choice of current year.
Have you any easy solution?
thnx.
I'm not entirely sure I understand the requirement.
Also, since this is a new topic and future people (Hello, people from the future! Have you invented transportation yet?) will be searching for probably the same solution, could you open a new thread, explaining precisely what the req. is? I promise that either myself or other members will try our best to help!
Did you mean teleportation? I think we've got transportation already... :P
Quote from: Nimrod Avissar on 27 Feb 2014 09:43:53 AM
I'm not entirely sure I understand the requirement.
Also, since this is a new topic and future people (Hello, people from the future! Have you invented transportation yet?) will be searching for probably the same solution, could you open a new thread, explaining precisely what the req. is? I promise that either myself or other members will try our best to help!
As if by magic, it's now a new, separate topic :)
MF.
Transportation/Teleportation/Time Travel: I found $5 in a coat pocket that was put there by Past-Lynn. I was happy and said thank you to Past-Lynn. I also promised to put money in some other pocket for Future-Lynn to one day discover and enjoy, but alas, I am not to be relied upon for this sort of thing. Thankfully it has been shown that I am sometimes absent minded so there is hope that I might leave money somewhere for Future-Lynn to find. At least I'm not as ditzy as Past-Lynn who once left her entire wallet in a grocery store shopping cart.
;D ;D ;D
At least past-Lynn wasn't as absent-minded as Tony Bennett. He left his heart somewhere and had to write a song to remind himself where...
Let's get this discussion back on track, away from my embarrassing error:
Tequila, if my memory serves you're using a relational datasource. The text book solution (Albeit not the best or brightest) is to create two queries - one filtered by [Year]=?year? and [Month]=?month? and the other is filtered by [Year]=?year?-1 and [month]=?month?
Then join the queries, and use the joined query for the crosstab table. This will give you a field for each date period (Selected year-month and previous year-month).
Brighter, better solutions would use a total on a case statement, and dimensional data will make it even easier using parallelPeriod.