en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Jesper Bøgekvist  
#1 Posted : Tuesday, July 7, 2015 10:09:40 AM(UTC)
Jesper Bøgekvist
Rank: Member

Groups: extranet\Forum
Joined: 7/7/2015(UTC)
Posts: 9

Hi all

I have a cross table that shows salary "the last 12 months" and "the last 12 months before that".
It's dynamic so when the date turns 01/07 it shows "June 2015 - July 2014" and "June 2014 - July 2013".
The problem is that my salary data isn't updated until around the 10th each month, so "the last 12 months" isn't comparable until the 10th. Is there a way to postpone the dynamic update, so instead of changing the previous month the first it waits until the 10th?

Best regards,

Jesper Bøgekvist
Lotte Bjørn Jensen  
#2 Posted : Tuesday, July 14, 2015 2:17:10 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Hi Jesper

Here's a way of doing it.

You need have 5 comparisions.
1 with data from the last day in the previous month,
1 with data from June 2015 - July 2014,
1 with data from May 2015 - June 2014,
1 with data from June 2014 - July 2013,
1 with data from May 2014 - June 2013.

If there's data in the first comparision your data is updated for last month.
Then you should hide the 3th and the 5th comparision, otherwise you should hide the 2nd and the 4th.
Best regards

Lotte Bjørn
Jesper Bøgekvist  
#3 Posted : Tuesday, July 21, 2015 7:27:17 AM(UTC)
Jesper Bøgekvist
Rank: Member

Groups: extranet\Forum
Joined: 7/7/2015(UTC)
Posts: 9

Thanks a lot Lotte!!
Steffen Davidsen  
#4 Posted : Wednesday, July 22, 2015 7:31:53 AM(UTC)
Steffen Davidsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 7/8/2014(UTC)
Posts: 28

Originally Posted by: Jesper Bø Go to Quoted Post
Hi all

I have a cross table that shows salary "the last 12 months" and "the last 12 months before that".
It's dynamic so when the date turns 01/07 it shows "June 2015 - July 2014" and "June 2014 - July 2013".
The problem is that my salary data isn't updated until around the 10th each month, so "the last 12 months" isn't comparable until the 10th. Is there a way to postpone the dynamic update, so instead of changing the previous month the first it waits until the 10th?

Best regards,

Jesper Bøgekvist


Hi Jesper!

I tried to use Dreambroker to answer your question. Please let me know, if it did not solve your question. My apologies for the gebroken English :-).

https://dreambroker.com/channel/r95qfvsz/jsx950me

Best regards,
Steffen
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error