en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Morten  
#1 Posted : Wednesday, January 8, 2014 9:36:50 AM(UTC)
Morten
Rank: Advanced Member

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

Hi.

This is probably a simple matter, but I have not found the solution myself.

I have a simple cross table with two measures for each month (dynamic period). I wish to calculate the product of the two measures for each month.

Since I use dynamic periods, I would like the calculation to be "within" the current month, so that when I create a chart the months will be visible.

http://screencast.com/t/8CmjC5TYFn

How to?

Morten
Páll Bjarkason  
#2 Posted : Wednesday, January 8, 2014 2:06:59 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 164

Hi Morten

To get the decried result the calculation-type should be "as a measure"

Calculations "as a measure" are found in Calculations -> Custom calculation -> As a new measure

The calculation probably is something like sum(0,0,m1)*sum(0,0,m2)
Best regards

Páll, CTS
Morten  
#3 Posted : Wednesday, January 8, 2014 2:10:14 PM(UTC)
Morten
Rank: Advanced Member

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

Hi Páll.

Thank you. Just what I was looking for.

Morten
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