Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
#1 Posted : Thursday, September 12, 2013 7:41:52 PM(UTC)
Rank: Newbie

Groups: Administrators
Joined: 9/12/2013(UTC)
Posts: 1

We have a new table which has department and total expense. Can we add a new calculation if department = "Mgf", then 00?
thank you
Niels Thomsen  
#2 Posted : Friday, September 13, 2013 8:07:27 AM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: Administrators
Joined: 4/5/2011(UTC)
Posts: 105

Hi Ching

It can be done using the TARGIT syntax in a calculation.

In this crosstable:

I want to replace the value of the Item called Levis, Lime XL - which is part of the product group JEANS.

This calculation basically says - if we counted our way down to [JEANS].[Levis, Lime XL] then put a zero in else just transfer the current value unchanged
if count(d1, d1:0, m1) = count(d1, d1:@"[JEANS].[Levis, Lime XL]", m1) then 0 else sum(d1, 0, m1)

Then you just need to hide your original column and only look at the calculated one.

Hope it makes sense-
Hope it makes sense.

Best Regards
Niels Thomsen


Users browsing this topic
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.