en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Brian Sandfeld  
#1 Posted : Tuesday, October 1, 2013 12:53:13 PM(UTC)
Brian Sandfeld
Rank: Newbie

Groups: Administrators
Joined: 10/1/2013(UTC)
Posts: 1

Hallo

Can somebody help me with a simple question?
How do I make a column total on only one out of several columns?
If I select one of the measures/columns eg sum(0, all(v), m4), the sum from m4 will be seen under every measure/column!

Brian
Niels Thomsen  
#2 Posted : Tuesday, October 1, 2013 1:15:48 PM(UTC)
Niels Thomsen
Rank: Advanced Member

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

Hi Brian

This can be done a number of ways, but here is one way to go:

if sum(0, all(v), 0) = sum(0, all(v), m4) then sum(0, all(v), 0) else 0
This syntax says - if the total of the current measure equals the total of the m4 measure then we use it else we put in a zero.
Now you have one column that holds a calculated total of the visible rows and all the other columns that total is zero.

Then you could e.g. using number formatting choose that zeroes in the calculated row are shown with space (go to advanced number formatting and choose that minimum number of digits should be 0).

Hope it makes sense.
Hope it makes sense.

Best Regards
Niels Thomsen

https://dk.linkedin.com/in/ncthomsen


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