en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Jeremy Kimmons  
#1 Posted : Monday, June 10, 2013 4:56:19 PM(UTC)
Jeremy Kimmons
Rank: Member

Groups: extranet\Forum
Joined: 2/28/2013(UTC)
Posts: 9

Hi all

With my new, all-functioning dynamic time dimension (hooray!), I need to set up a simple cross-table showing sales per item for last week, and the same week last year.

I can create the table, adding the "last week" sales via dynamic time, but when I add "previous week previous year" by means of a comparison, the cross-table ONLY shows the comparison - the "last week" column disappears.

Am I approaching this in the wrong way? Should this be done via comparisons at all?



Cheers

Jeremy

Ole  
#2 Posted : Monday, June 10, 2013 9:42:59 PM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 324

Hi Jeremy,

You will need to do it with one comparison with two comparison elements. Do not add any global or local criteria.

One comparison element with criteria "last week" and the other comparison element with criteria "previous week previous year". The two comparison elements will then become the two desired columns in your crosstab.

Best regards,
Ole

Edited by user Monday, June 10, 2013 9:43:42 PM(UTC)  | Reason: Not specified

I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Jeremy Kimmons  
#3 Posted : Wednesday, June 12, 2013 2:25:00 PM(UTC)
Jeremy Kimmons
Rank: Member

Groups: extranet\Forum
Joined: 2/28/2013(UTC)
Posts: 9

Thanks Ole, worked a treat :)

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