 Rank: Advanced Member
Groups: extranet\Forum
Joined: 4/25/2016(UTC)
Posts: 16
|
Hi. I'm having some issues getting a calculation to work the way i would like to. Here is what i'm trying to do: I have a crosstable with 2 calculations and then i have added the "posting date" dimension   I would like to see the total number of workingdays without the "posting date" dimension:   Is this possible to achieve?
|
|
|
|
|
|
 Rank: Advanced Member
Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 183
|
Hi Tim
In the last screenshot, you have the correct values for the two measures on the all level. (0 and 13)
The all levels is one level higher than the year level. The year level is (0 and 13)
In addition, the Month level for June is (22 and 13)
On what Year-Month-Day level and for what period do you wish to report the two measures?
KR Páll
|
Best regards
Páll, CTS |
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 4/25/2016(UTC)
Posts: 16
|
Hi Páll
Thanks for your reply.
My main goal is to show the number of working days in a month, and what workingday it is today (MTD).
But my problem might be, the way i have constructed the measures
|
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 183
|
Ok. Now I understand.
I hope that I Can give you an idea of a possible design. The design requires deep TARGIT knowledge. 😞
Assuming a correct implementation off the measure...
You shold look into the TARGIT comparison element and dynamic time.
Using TARGIT comparison you could create 2 elements
1) Today
2) Max this month
Then you get a result that resembles the Your last screen shot.
I.e. Today's workDayNumber and the total number of workDays this month.
KR Páll |
Best regards
Páll, CTS |
|
|
|
|
|
Rank: Advanced Member
Groups: extranet\Forum
Joined: 4/25/2016(UTC)
Posts: 16
|
Thanks alot for your help.
I solved it by editing my measures in the SSAS
|
|
|
|
|
|
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.